Apple Numbers '08 Bedienungsanleitung PDF herunterladen (Seite 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.

1 2 ... 209 210 211 212 213 214 215 216 217 218 219 ... 294 295

Keine Kommentare

Apple Numbers '08 Bedienungsanleitung Seite 214