The Excel text functions are used to format the characters, find the text, replace the text, return the desired characters within the text and much more.
Complete List of Excel Text Functions (A to Z)
All Excel text functions are mentioned below in alphabetical order:
| Function | Description |
| ARRAYTOTEXT Function | Convert an array of text and non-text values into text. |
| BAHTTEXT Function | Convert a number to Thai text and adds a suffix of “Baht”. |
| CHAR Function | Provide the character based on a number. |
| CLEAN Function | Remove all nonprintable characters from the text. |
| CODE Function | Numeric code for the first character in the text. |
| CONCAT Function | Combine the text from multiple cells into a single cell. |
| DOLLAR Function | Convert the number to text using currency format, add $ sign and round the decimal points. |
| EXACT Function | Compare two text strings and results as True if both are exactly same, else results as False. |
| FIND Function | Search one text within another text and results their position. |
| FIXED Function | Round the number to a specified number of decimals, with/without comma and converts to text. |
| LEFT Function | Provide the specified number of characters from the beginning of the text string. |
| LEN Function | Provide the total number of characters in the text string. |
| LOWER Function | Convert all the uppercase letters in the text to lowercase. |
| MID Function | Provide the specified number of characters from the specified position of the text string. |
| NUMBERVALUE Function | Convert the text value to number by specified decimal and group separators. |
| PROPER Function | Convert the first character in the text as uppercase and rest as lowercase. |
| REPLACE Function | Replace part of the old text with new text based on the specified number of characters. |
| REPT Function | Repeat the text a specified number of times. |
| RIGHT Function | Provide the specified number of characters from the end of the text string. |
| SEARCH Function | Search one text within another text and provides the starting position number of the text. |
| SUBSTITUTE Function | Substitute the specific or all instances of the old text with the new text in a text string. |
| T Function | Check whether its text or not. |
| TEXT Function | Convert the number to text format. |
| TEXTAFTER Function | Get the text that occurs after the specified character or string. |
| TEXTBEFORE Function | Get the text that occurs before the specified character or string. |
| TEXTJOIN Function | Combine the text from multiple cells by adding a specified delimiter. |
| TEXTSPLIT Function | Split the text by using column and row delimiters. |
| TRIM Function | Remove all extra spaces before and after the text by keeping only one space between each word. |
| UNICHAR Function | Convert the number into Unicode character. |
| UNICODE Function | Convert the first Unicode character in the text into number. |
| UPPER Function | Convert all the lowercase letters in the text to uppercase. |
| VALUE Function | Convert a text that appears as number to a numeric value. |
| VALUETOTEXT Function | Convert the numeric value to text. |