| Text Functions | Description |
|---|---|
| CONCATENATE | Used to join as many as 255 text strings into a single text string |
| LEN | Returns the number of characters in a string |
| Takes a Portion of a Cell String and Places it in another Cell | |
| LEFT | Returns the number of characters you specify from the left side of a string. |
| MID | Returns the number of characters you specify from a string starting at the position you specify |
| RIGHT | Returns the number of characters you specify from the right side of a string |
| TEXTBEFORE | Returns the text that precedes a specified delimiter in a text string. |
| TEXTAFTER | Returns the text that follows a specified delimiter in a text string. It is perfect for extracting the latter part of strings. |
| Splits Cell data into Multiple Cells | |
| TEXTSPLIT | Takes parts of cell data and splits it into multiple cells that can be displayed in columns or rows. |
| Change the Case of a String | |
| LOWER | Converts a string to all lowercase letters |
| UPPER | Converts a string to all uppercase letters |
| PROPER | Capitalizes the first letter in a string and all other letters that follow any character other than a letter. All other characters in the string are converted to lowercase letters |
| Find a String within another String | |
| FIND | Returns the starting position of where one string is found in another string. It is case sensitive. |
| SEARCH | Returns the starting position of where one string is found in another string. It is not case sensitive. You can use wildcards in the search string. |
| Replace Part of a String with another String | |
| REPLACE | Replaces part of a text string with a different text string |
| SUBSTITUTE | Replaces existing text with new text. |