| 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 |
United Kingdom
Printer-Friendly Version
