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

 

 

Copyright © 2000-2016 StatsDirect Limited, all rights reserved. Download a free trial here.