COL

Returns the column number for the given cell or formula.

Syntax

COL({cell-reference})

Arguments

cell-reference

Cell name .  If omitted the function assumes the cell for the function.

Example

COL(A2) = 1

Column A is the first column in the spreadsheet.