| Function |
Description |
| ASC |
Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters |
| BAHTTEXT |
Converts a number to text, using the ß (baht) currency format |
| CHAR |
Returns the character specified by the code number |
| CLEAN |
Removes all nonprintable characters from text |
| CODE |
Returns a numeric code for the first character in a text string |
| CONCATENATE |
Joins several text items into one text item |
| DOLLAR |
Converts a number to text, using the $ (dollar) currency format |
| EXACT |
Checks to see if two text values are identical |
| FIND, FINDB |
Finds one text value within another (case-sensitive) |
| FIXED |
Formats a number as text with a fixed number of decimals |
| JIS |
Changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters |
| LEFT, LEFTB |
Returns the leftmost characters from a text value |
| LEN, LENB |
Returns the number of characters in a text string |
| LOWER |
Converts text to lowercase |
| MID, MIDB |
Returns a specific number of characters from a text string starting at the position you specify |
| PHONETIC |
Extracts the phonetic (furigana) characters from a text string |
| PROPER |
Capitalizes the first letter in each word of a text value |
| REPLACE, REPLACEB |
Replaces characters within text |
| REPT |
Repeats text a given number of times |
| RIGHT, RIGHTB |
Returns the rightmost characters from a text value |
| SEARCH, SEARCHB |
Finds one text value within another (not case-sensitive) |
| SUBSTITUTE |
Substitutes new text for old text in a text string |
| T |
Converts its arguments to text |
| TEXT |
Formats a number and converts it to text |
| TRIM |
Removes spaces from text |
| UPPER |
Converts text to uppercase |
| VALUE |
Converts a text argument to a number |
