CHAR | Get a character from a number | number |
CLEAN | Strip non-printable characters from text | text |
CODE | Get the code for a character | text |
CONCATENATE | Join text together | text1 text2text3 ... |
DOLLAR | Convert a number to text in currency format | number decimals |
EXACT | Compare two text strings | text1 text2 |
FIND | Get the location of text in a string |
|
LEFT | Extract text from the left of a string |
|
LEN | Get the length of text. |
|
LOWER | Convert text to lower case |
|
MID | Extract text from inside a string |
|
PROPER | Capitalize the first letter in each word |
|
REPLACE | Replace text based on location |
|
REPT | Repeat text as specified |
|
RIGHT | Extract text from the right of a string |
|
SEARCH | Get the location of text in a string |
|
SUBSTITUTE | Replace text based on content |
|
TEXT | Convert a number to text in a number format |
|
TRIM | Remove extra spaces from text |
|
UPPER | Convert text to upper case | textnum_chars |
VALUE | Convert text to a number | text |