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...
0

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...
0

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...
0

CONCATENATE Function

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

TRIM Function

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

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...
0

CODE Function

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

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...
0