Workbook Functions: String
CHAR(Number between 1 and 255)
Character that corresponds to the supplied ANSI code number.
See also: CODE
CLEAN(text)
Removes all non-printable characters from the supplied text.
See also: CHAR, TRIM
CODE(text)
Numeric code of the first character in the supplied string of text.
See also: CHAR
FIND(search text, text [,start position])
Searches for the specified search text within another text and returns the character position at which the search string first occurs. Start position in text where the search begins (default is 1).
See also: EXACT, LEN, MID, SEARCH
LEN(text)
Number of characters in the text string, spaces included.
See also: EXACT, SEARCH
LOWER(text)
Changes the characters in the specified text to lowercase.
See also: PROPER, UPPER
MID(text, start position, numchars)
Returns the specified number of characters in the text string, beginning at the specified start position.
See also: CODE, FIND, LEFT, RIGHT, SEARCH
REPLACE(original text, start position, number of characters, replacement text)
Replaces part of a text string with another text string.
See also: MID, SEARCH, TRIM
REPT(text, number)
Repeats a text string the specified number of times.
RIGHT(text [,number of characters])
Returns the rightmost characters from the text string.
See also: LEFT, MID
SEARCH(search text, text [,start position])
Locates the position of the first character of a specified text string (search text) within another text string. Start position is the character position where the search begins (default is 1).
See also: FIND, MID, REPLACE, SUBSTITUTE
SUBSTITUTE(text, old text, new text [, instance])
Replaces a specified text string (old text), occurring within another text string (text), with a new text string. Instance specifies the occurrence of old text to replace (omission replaces every instance), e.g. SUBSTITUTE ("Shipment 45, Bin 45", "45", "52", 2) returns Shipment 45, Bin 52.
See also: REPLACE, TRIM
TEXT(number, format)
Transforms the given number into text, using the specified formatting; e.g.: TEXT(34626.2, "MM/DD/YY") returns 10/19/94.
See also: DOLLAR, FIXED, T, VALUE
TRIM(text)
Removes all spaces from text except single spaces between words.
See also: CLEAN, MID, REPLACE, SUBSTITUTE
UPPER(text)
Changes the characters in a text to uppercase characters.
See also: LOWER, PROPER
VALUE(text)
Returns the specified text as a number.
See also: DOLLAR, FIXED, TEXT