This is the complete list of every Excel Function for text. For each function I have provided a description, the formula and in some cases an example. Where text is necessary I have included the word ‘text’ as an example and where a target cell is specified I have used ‘A1′. Where appropriate I have provided links to other uses for the functions.
This is very much a quick reference guide, if you need help using these formulas you should come on our Excel Training course aimed at beginners. If you’re already up to scratch with all of these functions and are looking for something more advanced then our Advanced Excel Training Course is right for you.
Microsoft Excel 2007 Text Functions
- ASC
Description: Changes double-byte characters (full-width) into single-byte characters (half-width) for Double-byte characters sets (DBCS).
Formula: =ASC(“text”)
- BAHHTEXT
Description: Changes numbers into Thai currency by changing the number to Thai text and adding the suffix “Baht”
Formula: =BAHTTEXT(A1)