| 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 |