The ‘COLUMN’ function in Excel will return the column number of a specified cell. Column A is returned as column 1, column B is column 2, and so on.
Note: if you wish to know the number of columns within a specified cell range, you will need to use the COLUMNS function instead.
In addition to the COLUMN function, you could also use the CELL function to return the column number for a specified cell. For example; =CELL(“col”,A1) would return the column number of cell A1.
reference – input cell (i.e. the cell which you want to know the column number of)
The COLUMN function will return the column number of a singular specified cell.