COLUMNS function

COLUMNS returns the column number of a cell reference.


If the reference is a cell, the column number of the cell is returned.


array is the reference to a cell or cell area whose first column number is to be found.


=COLUMNS(B5) returns 1 because a cell only contains one column.

=COLUMNS(A1:C5) equals 3. The reference comprises three columns.