Formulas and Functions

Chapter 11 Text Functions 307
Function Description
“LEN” (page 315 ) The LEN function returns the number of
characters in a string.
“LOWER” (page 316 ) The LOWER function returns a string that is
entirely lowercase, regardless of the case of the
characters in the specied string.
“MID” (page 316) The MID function returns a string consisting of
the given number of characters from a string
starting at the specied position.
“PROPER” (page 317 ) The PROPER function returns a string where
the rst letter of each word is uppercase and all
remaining characters are lowercase, regardless of
the case of the characters in the specied string.
“REPLACE” (page 318 ) The REPLACE function returns a string where a
specied number of characters of a given string
have been replaced with a new string.
“REPT” (page 319 ) The REPT function returns a string that contains
a given string repeated a specied number of
times.
“RIGHT” (page 319 ) The RIGHT function returns a string consisting of
the given number of characters from the right
end of a specied string.
“SEARCH” (page 320) The SEARCH function returns the starting
position of one string within another, ignoring
case and allowing wildcards.
“SUBSTITUTE” (page 322) The SUBSTITUTE function returns a string where
the specied characters of a given string have
been replaced with a new string.
“T” (page 323) The T function returns the text contained in a
cell. This function is included for compatibility
with tables imported from other spreadsheet
applications.
“TRIM” (page 323) The TRIM function returns a string based on a
given string, after removing extra spaces.
“UPPER” (page 324) The UPPER function returns a string that is
entirely uppercase, regardless of the case of the
characters in the specied string.
“VALUE” (page 325) The VALUE function returns a number value even
if the argument is formatted as text.