FIND, FINDB Function
Description The FIND and FINDB Functions locate one text string within a second text string, and return the number of the starting...
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...