Apple Numbers '08 - Manual (Page 214)

214 Chapter 12 Dictionary of Functions
CODE
The CODE function returns the Unicode code number of the first character in a
specified string.
CODE(text)
 text: A text expression or reference to a cell containing a text expression.
Notes
You can use the Character Palette, which you can enable in International preferences,
to view the code for a particular character.
You can use the CHAR function to do the opposite of the CODE function: convert a
numeric code into a text character.
COLUMN
The COLUMN function returns the column number of the specified cell or, if no cell is
specified, the column number of the cell that contains the function.
COLUMN([cell])
 cell: Optional; a cell reference. If omitted, COLUMN returns the column number of
the cell that contains the formula.
Examples
Suppose you copy what you believe to be the text "a b c d e f" from another application and paste it
into cell A1, but instead see "a b c ? ?d e f". You can try using CLEAN to remove the unexpected
characters:
CLEAN(A1) returns "a b c d e f".
Examples
CODE("A") returns 65, the character code for uppercase "A".
CODE("abc") returns 97 for lowercase "a".
CHAR(97) returns "a".
CODE(A3) returns "102" for lowercase "f".
CODE(" ") gives 1488.
Examples
COLUMN(B7) returns 2, the absolute column number of column B.
COLUMN() returns the column number of the cell that contains the function.