Text and data functions
| Function |
Description |
|---|---|
| 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 |
Finds one text value within another (case-sensitive). |
| FIXED |
Formats a number as text with a fixed number of decimals. |
| LEFT |
Returns the leftmost characters from a text value. |
| LEN |
Returns the number of characters in a text string. |
| LOWER |
Converts text to lowercase. |
| MID |
Returns a specific number of characters from a text string starting at the position you specify. |
| PROPER |
Capitalizes the first letter in each word of a text value. |
| REPLACE |
Replaces characters within text. |
| REPT |
Repeats text a given number of times. |
| RIGHT |
Returns the rightmost characters from a text value. |
| SEARCH |
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. |