TOCOL Function Explained
The TOCOL function in Microsoft Excel returns the column number of a cell reference. It takes a single argument, which is a cell reference, and returns the column number of that cell reference as a number. For example, TOCOL("A1") would return 1.
TOCOL Function Syntax
TOCOL(reference, row_num, column_num, area_num)
- reference – The cell reference to the top-left cell of the area from which the column is returned.
- row_num – The row number in the reference from which the column is returned.
- column_num – The column number in the reference from which the column is returned.
- area_num – The area number in the reference from which the column is returned.