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 ignores formatting differences. Use EXACT to test text being entered into a document. Syntax EXACT(text1, text2) Parameters Text1 Required. The first text string. Text2 Required. The second text…

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 that it applies) depends upon your language settings. This function converts a number to text using currency format, with the decimals rounded to the specified place. The format…

CONCATENATE Function

Description The CONCATENATE Function joins up to 255 text strings into one text string. The joined items can be text, numbers, cell references, or a combination of those items. For example, if your worksheet contains a person’s first name in cell A1 and the person’s last name in cell B1,…

TRIM Function

Description The CLEAN Function removes all spaces from text except for single spaces between words. Use TRIM on text that you have received from another application that may have irregular spacing. Syntax TRIM(text) Parameters Text Required. The text from which you want spaces removed. Remarks The TRIM function was designed…

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 may not print with your operating system. For example, you can use CLEAN to remove some low-level computer code that is frequently at the beginning and end of…

CODE Function

Description The CODE function returns a numeric code for the first character in a text string. If you want to return the character specified by the code number, please use CHAR Function. Syntax CODE(text) Parameters Text Required. The text for which you want the code of the first character. Examples…

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 full-width (double-byte) characters. If you want to change full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters, please use ASC function. Syntax WIDECHAR(text)…

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 255 specifying which character you want. The character is from the character set used by your computer. Examples The example may be easier to understand if you copy…