| LEFT | High | Extracts a portion of a string by specifying the number of characters from the beginning. |
| MID | High | Extracts a portion of a string by specifying the starting position and the number of characters to be extracted. |
| RIGHT | High | Extracts a portion of a string by specifying the number of characters from the end. |
| LEFTB | Low | Extracts a portion of a string by specifying the number of bytes from the beginning. |
| MIDB | Low | Extracts a portion of a string by specifying the starting position of the extraction and the number of bytes. |
| RIGHTB | Low | Extracts a portion of a string, specifying the number of bytes from the end. |
| SUBSTITUTE | High | Replace the specified string. |
| REPLACE | Middle | Replace specified character position & number of characters with specified string. |
| TRIM | Middle | Remove unnecessary spaces between and before and after words, leaving one space between words. |
| CLEAN | Middle | Delete characters that cannot be printed. |
| CONCATENATE | Low | Concatenate strings (old version) |
| CONCAT | High | Concatenate strings. |
| TEXT | Middle | Get a string with display format code (user-defined format) applied to a number or date. |
| VALUE | Middle | Converts a number or date/time entered as a string to a number (serial value of date/time). |
| TEXTJOIN | High | Concatenate strings by specifying the delimiter. |
| FIXED | Middle | Converts a number to a comma-separated formatted string, rounded to the specified number of digits. |
| ASC | Middle | Converts full-width characters to half-width characters. |
| JIS | Middle | Converts half-width characters to full-width characters. |
| YEN | Middle | Converts a numeric value to a string in yen format. |
| DOLLAR | Middle | Converts numeric values to dollar ($) format strings. |
| BAHTTEXT | Low | Converts numeric values to strings in baht (Thai currency) format. |
| NUMBERVALUE | Middle | Converts strings of numeric notation (decimal points and commas) from various languages into numbers. |
| REPT | Middle | Get a string that repeats the specified string a specified number of times. |
| UNICHAR | Low | Get the Unicode character corresponding to the number. |
| UNICODE | Low | Get the Unicode number corresponding to a character. |
| TEXTBEFORE | High | Get text up to the specified text. |
| TEXTAFTER | High | Get text after the specified text. |
| TEXTSPLIT | High | Divides text into cells based on a specified character. |
| PROPER | High | Only the first letter is converted to uppercase. |
| UPPER | High | Convert to upper case. |
| LOWER | High | Convert to lower case. |