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
Description: Changes double-byte characters (full-width) into single-byte characters (half-width) for Double-byte characters sets (DBCS).
Description: Changes numbers into Thai currency by changing the number to Thai text and adding the suffix “Baht”
Description: Displays the character defined by a number in a character set (Macintosh or ANSI on Windows).
Description: Removes non-printable characters from text.
Description: The opposite of CHAR, this returns the numeric code for a character.
Description: Combines multiple text entries into one.
If you are looking to save time on Excel then try these Top 10 Time Saving Excel Formulas.
Description: Converts a number to text and adds a currency symbol depending on language settings. More on Excel Dollar Signs.
Description: Looks at two text strings and shows TRUE if they are identical, FALSE if not. Is case-sensitive but ignores formatting.
Description: Finds a text value within a string of text. The example formula would find the first ‘S’ within the cell specified. Find is case-sensitive – use SEARCH if you don’t want a case-sensitive search.
If you are looking to find numbers then use our Finding Highest and Lowest Numbers in Excel guide.
Description: Converts a number to text and specifies the number of decimals.
Description: The reverse of ASC, converts single-byte characters into double-byte characters.
Description: Returns a specified number of characters from the left of a string of text.
Description: Returns the number of characters in a string of text.
Description: Converts all text in a cell to lowercase.
Description: Returns a specified number of characters from a string of text, from a specified start point. Good if you have a range of data which all has the same first word and you would like the data without it.
Description: Capitalises the first letter of each word in a string of text and converts all other letters into lowercase.
Description: Replaces a specified part of text with a new set of characters at defined point in the string of text.
Description: Repeats text a specified number of times.
Description: Similar to the LEFT function but returns text from the right of a string of text.
Description: Similar to FIND but is not case-sensitive. Finds the position of a specified text value within another.
Description: Replace a text value with a new text value within a cell. Use this for specific text, use REPLACE if you want to specify by location.
Description: Converts a value to text using a numeric format.
Formula: =A1&” is “&TEXT(A3,”0%”)&” great!”
Description: Removes all spaces except those within words.
Description: Changes all text into uppercase
Hopefully you will be able to find these formulas useful. If you have any problems leave a comment and we will try and help.
Stay tuned for more Excel Function lists.