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 value of a given cell reference specified by a text string.

VBA Code

Col_Number - VBA equivalent

Related Formulas

Convert column number to column letter

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