COLUMNNUMBER

COLUMNNUMBER —

COLUMNNUMBER(name)

COLUMNNUMBER function returns an integer corresponding to the column name supplied as a string.

If name is invalid, COLUMNNUMBER returns the #VALUE! error.

COLUMNNUMBER("E") equals 5.