Convert column letter to column number

You can convert the column letter into its corresponding column number

1=COLUMN(INDIRECT("A"&"1")) = 1
2=COLUMN(INDIRECT("B"&"1")) = 2
3=COLUMN(INDIRECT("C"&"1")) = 3
4=COLUMN(INDIRECT("Z"&"1")) = 26
5=COLUMN(INDIRECT("AZ"&"1")) = 52

Built-in Functions

COLUMN - The column number of a cell reference.
INDIRECT - The text string of the contents of a given cell reference.

VBA Code

Col_Number - VBA equivalent

Related Formulas

Convert column number to column letter

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top