=COLUMN(A1) The COLUMN function returns the column number of the given cell reference. =COLUMN(D10) returns 4 because column D is the fourth column.