# Excel text functions

> Text functions pull pieces out of strings, clean up imported data and join values into labels.

Source: https://spreadsheetpractice.com/functions/category/text · Updated October 29, 2026

Text functions pull pieces out of strings, clean up imported data and join values into labels. Most real cleanup is a short chain of them: TRIM the spaces, fix the case with PROPER, then split with TEXTBEFORE, or with LEFT and FIND in older versions.

## Which one to use

| You want to | Use | Why |
|---|---|---|
| Remove extra spaces from imported data | [TRIM](https://spreadsheetpractice.com/functions/trim) | Strips leading, trailing and repeated spaces in one step, the first fix when lookups fail. |
| Split text at a character, like the @ in an email | [TEXTBEFORE](https://spreadsheetpractice.com/functions/textbefore) | No position math, and TEXTAFTER returns the other half. In older versions, use LEFT with FIND. |
| Take a fixed number of characters from the start | [LEFT](https://spreadsheetpractice.com/functions/left) | Best for codes with a fixed-length prefix. RIGHT and MID handle the end and the middle. |
| Join a list into one cell with commas | [TEXTJOIN](https://spreadsheetpractice.com/functions/textjoin) | Puts the delimiter between items and can skip blanks. |
| Show a number or date inside a sentence | [TEXT](https://spreadsheetpractice.com/functions/text) | Keeps formatting like $1,250.00 or Mar 7 when you join values with &. |
| Check whether a cell contains a word | [SEARCH](https://spreadsheetpractice.com/functions/search) | Wrap it in ISNUMBER for a TRUE or FALSE answer that ignores case. |

## All 29 text functions

| Function | What it does | Available in |
|---|---|---|
| [CHAR](https://spreadsheetpractice.com/functions/char) | CHAR returns the character for a code number. | Every current version |
| [CLEAN](https://spreadsheetpractice.com/functions/clean) | CLEAN removes non-printing characters, such as line breaks and tabs, from text. | Every current version |
| [CODE](https://spreadsheetpractice.com/functions/code) | CODE returns the numeric code of the first character in a text string. | Every current version |
| [CONCAT](https://spreadsheetpractice.com/functions/concat) | CONCAT joins text from several cells or whole ranges into one string. | Excel 2019 and later, including Microsoft 365 |
| [CONCATENATE](https://spreadsheetpractice.com/functions/concatenate) | CONCATENATE joins up to 255 text items into one string. | Every current version |
| [EXACT](https://spreadsheetpractice.com/functions/exact) | EXACT compares two text values and returns TRUE only if they match exactly, including upper and lower case. | Every current version |
| [FIND](https://spreadsheetpractice.com/functions/find) | FIND returns the position of one piece of text inside another, counting from 1. | Every current version |
| [LEFT](https://spreadsheetpractice.com/functions/left) | LEFT returns a set number of characters from the start of a text string. | Every current version |
| [LEN](https://spreadsheetpractice.com/functions/len) | LEN counts the characters in a text string, including spaces and punctuation. | Every current version |
| [LOWER](https://spreadsheetpractice.com/functions/lower) | LOWER converts every letter in a text string to lowercase and leaves numbers and symbols alone. | Every current version |
| [MID](https://spreadsheetpractice.com/functions/mid) | MID returns characters from the middle of a text string, starting at a position you choose. | Every current version |
| [NUMBERVALUE](https://spreadsheetpractice.com/functions/numbervalue) | NUMBERVALUE converts text that looks like a number into a real number, using the decimal and thousands separators you name rather than your computer's settings. | Excel 2013 and later |
| [PROPER](https://spreadsheetpractice.com/functions/proper) | PROPER capitalizes the first letter of each word and lowercases the rest. | Every current version |
| [REGEXEXTRACT](https://spreadsheetpractice.com/functions/regexextract) | REGEXEXTRACT pulls out the part of a text that matches a regular expression: an order number, an email domain, the digits in a messy code. | Microsoft 365 only |
| [REGEXREPLACE](https://spreadsheetpractice.com/functions/regexreplace) | REGEXREPLACE replaces the parts of a text that match a regular expression. | Microsoft 365 only |
| [REGEXTEST](https://spreadsheetpractice.com/functions/regextest) | REGEXTEST checks whether text contains a match for a regular expression and returns TRUE or FALSE. | Microsoft 365 only |
| [REPLACE](https://spreadsheetpractice.com/functions/replace) | REPLACE swaps out a set number of characters at a given position, whatever those characters are. | Every current version |
| [REPT](https://spreadsheetpractice.com/functions/rept) | REPT repeats a piece of text a given number of times. | Every current version |
| [RIGHT](https://spreadsheetpractice.com/functions/right) | RIGHT returns a set number of characters from the end of a text string. | Every current version |
| [SEARCH](https://spreadsheetpractice.com/functions/search) | SEARCH returns the position of one piece of text inside another, ignoring upper and lower case, and it understands the ? and * wildcards. | Every current version |
| [SUBSTITUTE](https://spreadsheetpractice.com/functions/substitute) | SUBSTITUTE replaces specific text with new text everywhere it appears, or only at the occurrence you choose. | Every current version |
| [TEXT](https://spreadsheetpractice.com/functions/text) | TEXT turns a number or date into text in the format you choose, such as "$1,250.00" or "March 2026". | Every current version |
| [TEXTAFTER](https://spreadsheetpractice.com/functions/textafter) | TEXTAFTER returns everything after a delimiter, such as the domain after the @ or the last part of a file path. | Excel 2024 and Microsoft 365 |
| [TEXTBEFORE](https://spreadsheetpractice.com/functions/textbefore) | TEXTBEFORE returns everything before a delimiter you name, such as the username before the @ in an email or the first name before a space. | Excel 2024 and Microsoft 365 |
| [TEXTJOIN](https://spreadsheetpractice.com/functions/textjoin) | TEXTJOIN joins a list of values with the same delimiter between each one, and can skip blanks. | Excel 2019 and later, including Microsoft 365 |
| [TEXTSPLIT](https://spreadsheetpractice.com/functions/textsplit) | TEXTSPLIT splits text into separate cells at a delimiter: across columns, down rows, or both. | Excel 2024 and Microsoft 365 |
| [TRIM](https://spreadsheetpractice.com/functions/trim) | TRIM removes spaces from the start and end of text and shrinks runs of spaces between words to one. | Every current version |
| [UPPER](https://spreadsheetpractice.com/functions/upper) | UPPER converts every letter in a text string to capitals. | Every current version |
| [VALUE](https://spreadsheetpractice.com/functions/value) | VALUE converts text that looks like a number into a real number Excel can add, average and compare. | Every current version |

## Comparisons

- [FIND vs SEARCH](https://spreadsheetpractice.com/functions/compare/find-vs-search): Both return the position of text inside other text. FIND is case-sensitive and takes the text literally; SEARCH ignores case.
- [CONCAT vs TEXTJOIN vs &](https://spreadsheetpractice.com/functions/compare/concat-vs-textjoin): All three join text. The & operator is fine for two or three pieces.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
