Apple numbers User Manual

    Dictionary of Functions 

 

  

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.

  

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.

  

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".

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.

COLUMN(B7) returns 2, the absolute column number of column B.

COLUMN() returns the column number of the cell that contains the function.