| ARRAYTOTEXT | Converts a set of values into either an array constant or a comma-delimited list. | |
| BAHTTEXT | Expresses a number as a monetary amount in Thailand’s language and currency. | |
| CHAR | Translates a number into the character to which it corresponds in the character set of your computer. | |
| CLEAN | | |
| CODE | | |
| CONCAT | Generates a text value by combining several other values together. | CONCATENATE |
| DOLLAR | Transforms a numeric value into a text value and applies currency formatting to the result. | |
| EXACT | Compares two text values and returns TRUE if they’re identical, or FALSE if they are different. | |
| FIND | Searches for and returns the location of one text value in another text value. | |
| FINDB | | |
| FIXED | Converts a numeric value, or a value that can be interpreted as one, into a text value. | |
| LEFT | Returns a subset of a text value’s characters, taken from its left-hand side. | |
| LEN | Counts and returns the number of characters in a text value. | |
| LOWER | Transforms all upper-case characters in a piece of text to lower case. | |
| MID | Returns a subset of the characters contained in a text value. | |
| NUMBERVALUE | | |
| PROPER | Capitalizes the first letter of every word within a text value. | |
| REPLACE | Swaps a section of a text value for another text value. | |
| REPT | Generates a text value containing 1 or more copies of another text value. | |
| RIGHT | Returns a subset of a text value’s characters, taken from its right-hand side. | |
| SEARCH | Searches for and returns the location of one text value in another text value. | |
| SUBSTITUTE | Swaps a sequence of characters in a text value for another text value. | |
| T | | |
| TEXT | Converts a value to text and changes its appearance with a format code. | |
| TEXTAFTER | Returns everything from a text value following the appearance of a delimiter within it. | |
| TEXTBEFORE | Returns everything from a text value preceding the appearance of a delimiter within it. | |
| TEXTJOIN | Generates a text value by combining several other values together. | |
| TEXTSPLIT | Splits text values into parts, and places each one into a different cell. | |
| TRIM | Replaces sequences of 2 or more spaces with a single space and removes leading and trailing spaces. | |
| UNICHAR | Translates a number into its corresponding unicode character. | |
| UNICODE | Returns the unicode number of the first character in a text value. | |
| UPPER | Transforms all lower-case characters in a text value to upper case. | |
| VALUE | Converts a value’s data type to number. | |
| VALUETOTEXT | Converts a value of any type to a text value. | |