How to Get Excel Column Index From Alphanumeric?



Hello, what I want is the opposite of this post:

Supposed we have Column A, need to get the column index of it (which is 1), like below:

Input —> Desired Output:
A —> 1
E —> 5
P —> 16
AP —> 42
CB —> 80

Does anybody know how convert the alphanumeric to number?


Hi @whyyouandi,

Its here,


Uuups. Keep wondering how you searched that post, @Dominic .
Sorry for asking something posted before, thank you.


I bookmark posts that are new to me and asked very often :stuck_out_tongue:


Haha. Anyway thank you @Dominic, will try to search better next time :wink: