EXACT Function

Description The EXACT Function Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise. EXACT is case-sensitive but […]

DOLLAR Function

Description The DOLLAR Function converts a number to text format and applies a currency symbol. The name of the function (and the symbol […]

CONCATENATE Function

Description The CONCATENATE Function joins up to 255 text strings into one text string. The joined items can be text, numbers, cell […]

TRIM Function

Description The CLEAN Function removes all spaces from text except for single spaces between words. Use TRIM on text that you have […]

CLEAN Function

Description The CLEAN Function removes all non-printable characters from text. Use CLEAN on text imported from other applications that contains characters that […]

CODE Function

Description The CODE function returns a numeric code for the first character in a text string. If you want to return the […]

WIDECHAR Function

Description For Double-byte character set (DBCS) languages, The WIDECHAR function Changes half-width (single-byte) English letters or katakana within a character string to […]

CHAR Function

Description The CHAR function returns the character specified by the code number. Syntax CHAR(number) Parameters Number Required. A number between 1 and […]