| Functions |
What it Does |
| LEFT |
Returns the leftmost characters
from a text value |
| LEN |
Returns the number of characters
in a text string |
| MID |
Returns
a specific number of characters from a text string starting at the position
you specify |
| RIGHT |
Returns the rightmost characters
from a text value |
| TRIM |
Removes
spaces from text |
| FIND |
Finds
one text value within another (case-sensitive) |
| REPT |
Repeats text a given number of
times |
| TEXT |
Formats a number and converts it
to text |
| VALUE |
Converts a text argument to a
number |
| CONCATENATE |
Joins several text items into
one text item |
| 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 |
| DOLLAR |
Converts a number to text, using
the $ (dollar) currency format |
| EXACT |
Checks to see if two text values
are identical |
| FIXED |
Formats a number as text with a
fixed number of decimals |
| LOWER |
Converts text to lowercase |
| PROPER |
Capitalizes the first letter in
each word of a text value |
| REPLACE |
Replaces characters within text |
| 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 |
| UPPER |
Converts text to uppercase |
Back home