COLUMNS function
COLUMNS returns the column number of a cell reference.
Syntax
If the reference is a cell, the column number of the cell is returned.
COLUMNS(array)
array is the reference to a cell or cell area whose first column number is to be found.
Example
=COLUMNS(B5) returns 1 because a cell only contains one column.
=COLUMNS(A1:C5) equals 3. The reference comprises three columns.