Skip to content

Text Functions

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.