Formulas and Functions

306
The text functions help you work with strings of characters.
Listing of Text Functions
iWork provides these text functions for use with tables.
Function Description
“CHAR” (page 308) The CHAR function returns the character that
corresponds to a decimal Unicode character
code.
“CLEAN” (page 308) The CLEAN function removes most common
nonprinting characters (Unicode character codes
0–31) from text.
“CODE” (page 309) The CODE function returns the decimal Unicode
number of the rst character in a specied string.
“CONCATENATE” (page 310 ) The CONCATENATE function joins (concatenates)
strings.
“DOLLAR” (page 3 11 ) The DOLLAR function returns a string formatted
as a dollar amount from a given number.
“EXACT” (page 312 ) The EXACT function returns TRUE if the argument
strings are identical in case and content.
“FIND” (page 312 ) The FIND function returns the starting position of
one string within another.
“FIXED” (page 313 ) The FIXED function rounds a number to the
specied number of decimal places and then
returns the result as a string value.
“LEFT” (page 314 ) The LEFT function returns a string consisting of
the specied number of characters from the left
end of a given string.
11
Text Functions