Text
Char
Description: Returns the character whose number code is defined in the parameter.
Example:Β
Char(number)
Clean
Description: Removes the non-printable characters from the given text, represented by number 0 to 31 of the 7-bit ASCII code.
Example:Β
Clean(text)
CONCATENATE
Description: Joins arguments into a single string.
Example:Β
CONCATENATE (text1, text2,...)
Dollar
Description: Converts a number to text, using a currency format.
Example:Β
Dollar (number, decimal_places)
LEFT
Description: Returns the first character or characters in a text string, based on the number of characters you specify.
Example:Β
LEFT(text, num_chars)
LEN
Description: Returns the length of a string .
Example:Β
LEN(text)
Lower
Description: Converts all characters in the specified text string to lowercase. Characters in the string that are not letters, are not changed.
Example:Β
Lower(text)
MID
Description: Returns a text segment of a character string.
Example:Β
MID(text, start_position, num_chars)
RIGHT
Description: Returns the last character or characters in a text string, based on the number of characters you specify.
Example:Β
RIGHT(text, num_chars)
SUBSTITUTE
Description: Substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to replace specific text in a text string use REPLACE when you want to replace any text that occurs in a specific location in a text string.
Example:Β
SUBSTITUTE(text, old_text, new_text, instance_num)
TEXT
Description: Returns a formatted string.
Example:Β
TEXT(value, format_text)
Trim
Description: Returns a text value with the leading and trailing spaces removed.
Example:Β
Trim( text )
Upper
Description: Converts all characters in a text string to uppercase.
Example:Β
Upper( text )
Value
Description: Returns a number from a string.
Example:Β
Value(range)