Excel offers a variety of text functions that allow you to manipulate text strings within your spreadsheets. These functions can be useful for formatting text, extracting specific parts of text, and performing text-based calculations. By effectively using these text functions, you can automate tasks, format data, and create more sophisticated spreadsheets.
By mastering these text functions, you can efficiently manipulate and format text data in Excel to create clear and informative reports.
| Function | Version | Purpose | Arguments |
|---|---|---|---|
| CHAR | Excel 2003 | Get a character from a number | number |
| CLEAN | Excel 2003 | Strip non-printable characters from text | text |
| CODE | Excel 2003 | Get the code for a character | text |
| CONCAT | Excel 2019 | Join text values without delimiter | text1 text2 … |
| CONCATENATE | Excel 2003 | Join text together | text1 text2 text3 … |
| DOLLAR | Excel 2003 | Convert a number to text in currency format | number decimals |
| EXACT | Excel 2003 | Compare two text strings | text1 text2 |
| FIND | Excel 2003 | Get the position of one text string inside another | find_text within_text start_num |
| FIXED | Excel 2003 | Format number as text with fixed decimals | number decimals no_commas |
| LEFT | Excel 2003 | Extract text from the left of a string | text num_chars |
| LEN | Excel 2003 | Get the length of text. | text |
| LOWER | Excel 2003 | Convert text to lower case | text |
| MID | Excel 2003 | Extract text from inside a string | text start_num num_chars |
| NUMBERVALUE | Excel 2013 | Convert text to number with custom separators | text decimal_separator group_separator |
| PROPER | Excel 2003 | Capitalize the first letter in each word | text |
| REPLACE | Excel 2003 | Replace text based on location | old_text start_num num_chars new_text |
| REPT | Excel 2003 | Repeat text as specified | text number_times |
| RIGHT | Excel 2003 | Extract text from the right of a string | text num_chars |
| SEARCH | Excel 2003 | Get the location of substring in a string | find_text within_text start_num |
| SUBSTITUTE | Excel 2003 | Replace text based on content | text old_text new_text instance |
| TEXT | Excel 2003 | Convert a number to text with a number format | value format_text |
| TEXTJOIN | Excel 2019 | Join text values with a delimiter | delimiter ignore_empty text1 text2 … |
| TRIM | Excel 2003 | Remove extra spaces from text | text |
| UNICHAR | Excel 2013 | Get Unicode character by number | number |
| UNICODE | Excel 2013 | Get number from Unicode character | text |
| UPPER | Excel 2003 | Convert text to upper case | text |
| VALUE | Excel 2003 | Convert text to a number | text |