EasySpreadsheet includes functions for repeating, joining, and comparing text strings. You may also convert strings to numbers, test values for text, remove blank spaces or nonprintable characters, and determine ASCII codes.
REPT (text, number): Repeats the text a certain number of times. The text can be a text string (e.g., "abc"), a number (e.g., 9), or a cell reference (e.g., C4). The number must be positive, and if the number is 0, nothing will be returned. For example, REPT("z", 4) would return "zzzz", REPT("z", 0) would return "", and REPT("z", -1) would return the #VALUE! error message.
CONCATENATE (text1, text2, ...): Joins several text items into one text item. These items can be text strings, numbers, or cell references. For example, if the value 50 was in cell B5, then CONCATENATE("I have ", B5, " oranges") would return "I have 50 oranges". (Note: This is the same as the formula ="I have " & B5 & " oranges".)
EXACT (expression1, expression2): Compares expression1 and expression2 for identical, case-sensitive matches. TRUE is returned if the expressions are identical; FALSE is returned if they are not.
T (value): Tests the value, and returns the value if it is text. For example, T("Hello") would return "Hello", while T(100) would return nothing.
VALUE (text): Converts text to a numerical value. The text string must be in a number format (i.e., words cannot be converted to numbers). For example, VALUE("$6.00") would return 6, while VALUE("dog") would return the #VALUE! error message. (Note: EasySpreadsheet automatically converts text to numbers for you.)
Removal Functions
TRIM (text): Removes all blank spaces from the text, except for single spaces between words. For example, TRIM(" One Two Three ") would return "One Two Three".
CLEAN (text): Removes all nonprintable characters from the supplied text.
ASCII Code Functions
CHAR (number): Returns the character that corresponds to the supplied ASCII code (number). The number must be between 1 and 255. For example, CHAR(83) would return "S".
CODE (text): Returns the ASCII code for the first character of the text. The text must be enclosed in double quotes. For example, both CODE("Sunday") and CODE("S") would return 83, which is the ASCII code for S.