How to Get Excel Column Index From Alphanumeric?

excel
studio

#1

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?


#2

Hi @whyyouandi,

Its here,


#3

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


#4

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


#5

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