Function | Description |
|---|---|
ASC | Converts double-byte characters into single-byte characters |
BAHTTEXT | Converts a number into Thai characters using the currency format Baht |
CHAR | Returns the code of a character |
CLEAN | Deletes all nonprintable characters from the text |
CODE | Returns the code of the first character in a string |
CONCATENATE | Combines several strings into one string |
DOLLAR | Converts a number in text using the $ currency format |
EXACT | Checks whether two strings are exactly the same |
FIND | Searches for a string within another string (case-sensitive) |
FINDB | Searches for a string within another string and returns the number of the initial position starting at the first character based on the bytes of each character; this function is used for double-byte characters |
FIXED | Formats a number as a string with a specified number of decimal places |
LEFT | Returns the first characters in a string |
LEFTB | Returns the first characters in a string; this function is used for double-byte characters |
LEN | Returns the number of characters in a string |
LENB | Returns the number of characters in a string; this function is used for double-byte characters |
LOWER | Converts text into lowercase |
MID | Returns the number of characters in a string starting at the indicated position |
MIDB | Returns the number of characters in a string starting at the indicated position; this function is used for double-byte characters |
PHONETIC | Extracts the phonetic (Furigana) characters from a string |
PROPER | Converts the first character of all words in the text into uppercase |
REPLACE | Replaces characters within a string |
REPLACEB | Replaces part of a string with another string; this function is used for double-byte characters |
REPT | Repeats text a given number of times |
RIGHT | Returns the last characters in a string |
RIGHTB | Returns the last characters in a string; this function is used for double-byte characters |
SEARCH | Searches for a string within another string (not case-sensitive) |
SEARCHB | Searches for a string within another string (not case-sensitive); this function is used for double-byte characters |
SUBSTITUTE | Replaces part of a string with a new string |
T | Converts an argument into a string |
TEXT | Formats a number and converts it into a string |
TRIM | Deletes redundant spaces from a string |
UPPER | Converts text into uppercase |
VALUE | Converts a text argument into a number |