| CHAR | Get a character from a number | number |
| CLEAN | Strip non-printable characters from text | text |
| CODE | Get the code for a character | text |
| CONCATENATE | Join text together | text1 text2text3 ... |
| DOLLAR | Convert a number to text in currency format | number decimals |
| EXACT | Compare two text strings | text1 text2 |
| FIND | Get the location of text in a string |
|
| LEFT | Extract text from the left of a string |
|
| LEN | Get the length of text. |
|
| LOWER | Convert text to lower case |
|
| MID | Extract text from inside a string |
|
| PROPER | Capitalize the first letter in each word |
|
| REPLACE | Replace text based on location |
|
| REPT | Repeat text as specified |
|
| RIGHT | Extract text from the right of a string |
|
| SEARCH | Get the location of text in a string |
|
| SUBSTITUTE | Replace text based on content |
|
| TEXT | Convert a number to text in a number format |
|
| TRIM | Remove extra spaces from text |
|
| UPPER | Convert text to upper case | textnum_chars |
| VALUE | Convert text to a number | text |