How to Get Excel Column Index From Alphanumeric?

Help
,
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,

1 Like
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:

1 Like
5

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