Apple iWork '09 User Manual
Page 307
Chapter 11
Text Functions
307
Function
Description
The LEN function returns the number of
characters in a string.
The LOWER function returns a string that is
entirely lowercase, regardless of the case of the
characters in the specified string.
The MID function returns a string consisting of
the given number of characters from a string
starting at the specified position.
The PROPER function returns a string where
the first letter of each word is uppercase and all
remaining characters are lowercase, regardless of
the case of the characters in the specified string.
The REPLACE function returns a string where a
specified number of characters of a given string
have been replaced with a new string.
The REPT function returns a string that contains
a given string repeated a specified number of
times.
The RIGHT function returns a string consisting of
the given number of characters from the right
end of a specified string.
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 specified characters of a given string have
been replaced with a new string.
The T function returns the text contained in a
cell. This function is included for compatibility
with tables imported from other spreadsheet
applications.
The TRIM function returns a string based on a
given string, after removing extra spaces.
The UPPER function returns a string that is
entirely uppercase, regardless of the case of the
characters in the specified string.
The VALUE function returns a number value even
if the argument is formatted as text.