Microsoft Office Tutorials and References
In Depth Information
Text Functions
Returns the number of characters in a text string.
LEN
Converts all uppercase letters in a text string to lowercase.
LOWER
Returns a specific number of characters from a text string, starting
at the position you specify.
MID
Capitalizes the first letter in a text string and any other letters in
text that follow any character other than a letter.
PROPER
Replaces a portion of a text string with a different text string
based on the number of characters you specify.
REPLACE
Replaces part of a text string with a different text string based on
the number of bytes you specify.
REPLACEB
Repeats text a given number of times.
REPT
Returns the last character or characters in a text string.
RIGHT
Returns the number of the character at which a specific character
or text string is first found, reading from left to right. SEARCH is
not case sensitive and can include wildcard characters.
SEARCH
Returns the number of the character at which a specific character
or text string is first found, reading from left to right.
SEARCHB
Substitutes new_text for old_text in a text string.
SUBSTITUTE
Returns the text referred to by value.
T
Converts a value to text in a specific number format.
TEXT
Removes all spaces from text except for single spaces between
words.
TRIM
Converts text to uppercase.
UPPER
Converts a text string that represents a number to a number.
VALUE
Search JabSto ::




Custom Search