column

Column number of a reference.

Syntax

v = column(reference)

Description

Returns the column number (A=1, B=2, …) of reference. Without arguments, returns the column of the cell containing the formula.

Examples

column()           % current column
column(C1)        % 3

See also

• row — Row number of a reference.
• columns — Number of columns in a reference.
• address — Cell address as a text string.