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,

1 Like

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:

1 Like

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