| 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 |