Apple iWork '09 - Manual (Page 308)

CHAR
The CHAR function returns the character that corresponds to a decimal Unicode
character code.
CHAR(code-number)
 code-number: A number for which you want to return the corresponding Unicode
character. code-number is a number value and must be greater than or equal to 32,
less than or equal to 65,535, and not equal to 127. If there is a decimal portion, it is
ignored. Note that character 32 is the space character.
Usage Notes
Not all Unicode numbers are associated with a printable character. Â
You can use the Special Characters window, which is available on the Edit menu, to Â
view entire sets of characters and their codes.
The CODE function returns the numeric code for a specific character.
Â
Examples
=CHAR(98.6) returns “b”, which is represented by the code 98. The decimal portion of the number is
ignored.
=CODE(”b”) returns 98.
Related Topics
For related functions and additional information, see:
“CODE” on page 309
“Listing of Text Functions” on page 306
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
CLEAN
The CLEAN function removes most common nonprinting characters (Unicode
character codes 0–31) from text.
CLEAN(text)
 text: The text from which you want to remove nonprinting characters. text can
contain any value type.
308 Chapter 11 Text Functions