BASE converts a positive integer to a specified base into a text from the numbering system. The digits 0-9 and the letters A-Z are used.
CONCATENATE combines several text strings into one string.
EXACT compares two text strings and returns TRUE if they are identical. This function is case-sensitive.
LEFT returns the first character or characters in a text string.
LEN returns the length of a string including spaces.
LOWER converts all uppercase letters in a text string to lowercase.
Returns the specified portion of a string expression
PROPER capitalizes the first letter in all words of a text string.
REPLACE replaces part of a text string with a different text string. This function can be used to replace both characters and numbers, which are automatically converted to text. The result of the function is always displayed as text.
REPT repeats a character string by the given number of copies. The result can be a maximum of 255 characters.
RIGHT defines the last character or characters in a text string.
In languages that use the double-byte character set, RIGHTB returns the specified number of bytes at the end of a text string.
SEARCH returns the position of a text segment within a character string. You can set the start of the search as an option. The search text can be a number or any sequence of characters. The search is not case-sensitive.
SUBSTITUTE replaces old text with new text in a string.
TEXT converts a number into text according to a given format.
TRIM removes spaces that are in front of a string, or aligns cell contents to the left.
UPPER converts the string specified in the text
field to uppercase.