| CHAR |
Returns the character specified by a number. |
| CLEAN |
Removes all nonprintable characters from text. |
| CODE |
Returns a numeric code from the first character in a text string. The opposite of the CHAR function. |
| CONCATENATE |
Joins several text strings into one text string. |
| DOLLAR |
Converts a number to text using Currency format, with the decimals rounded to the specified place. |
| EXACT |
Compares two text strings and returns TRUE if they are exactly the same, and FALSE otherwise. |
| FIND |
Locates one text string within another text string, and returns the number of the starting position of of FIND_TEXT from the leftmost character of WITHIN_TEXT. |
| FINDB |
Returns the position of specified text within another specified text string based on the number of bytes each character uses from the first character of WITHIN_TEXT. |
| FIXED |
Rounds a number to a specified number of decimals, formats the number in decimal format using a period and commas, and returns the result as text. |
| LEFT |
Returns the first character(s) in a text string. |
| LEFTB |
Returns the first character(s) in a text string based on a specified number of bytes |
| LEN |
Returns the number of characters in a text string. |
| LENB |
Returns the number of characters in a text string expressed in bytes. |
| LOWER |
Converts all letters in a text string to lowercase. |
| MID |
Returns a specific number of characters from a text string starting at the position you specify. |
| MIDB |
Returns a group of characters based on a specified number of bytes from a text string starting at the position you specify. |
| PROPER |
Capitalizes the first letter of each word in a text string or sentence. |
| REPLACE |
Replaces part of a text string with a different text string based on the number of characters you specify. |
| REPLACEB |
Replaces part of a text string with a different text string based on the number of characters you specify in terms of bytes. |
| REPT |
Repeats specified text a given number of times. |
| RIGHT |
Returns the last character(s) in a text string. |
| RIGHTB |
Returns the last character(s) in a text string based on a specified number of bytes. |
| SEARCH |
Returns the number of the character at which a specific character or text string is first found, reading from left to right. |
| SEARCHB |
Returns the number of the character at which a specific character or text string is first found in bytes, reading from left to right. |
| SUBSTITUTE |
Substitutes NEW_TEXT for OLD_TEXT in a string. |
| T |
Returns the text referred to by a value. |
| TEXT |
Converts a value to text in a specific number format. |
| TRIM |
Removes all spaces from text except single spaces between words. |
| UPPER |
Converts text to uppercase. |
| USDOLLAR |
Converts a number to text using US Dollar format, with the decimals rounded to the specified place. |
| VALUE |
Converts a text string that represents a number to a number. |