Home > Forum Home > Automating Data Analysis Tasks > Convert numbers to a specific text string > Using the apostrophe to specify text | Share |
Forum Topic | Login |
Using The Apostrophe To Specify Text | Rate this: (3.5/5 from 2 votes) |
You can specify values as test by preceding them with a single apostrophe '. It seems as through you want to wrap text into tags. To do this, you can concatenate text using the & sign e.g. ="<Time>" & A1 & "</Time>". | ||
Excel Business Forums Administrator | ||
Posted by Excel Helper on |
View Full Post |
Find relevant Excel templates and add-ins for Using the apostrophe to specify text in the Excel Business Solutions Directory |