How to convert an alphabet to numbers

[julioarriaga]

I wish to know if a function that does the following exists:

Input->Output

A->1

B->2

C->3

...

So on and so forth.

Thanks and regards.

[swuehl · Accepted solution]

Maybe

=Ord(INPUT) - 64

like

=ORD('A')-64

[sunny_talwar]

Or may be this

Match(INPUT, 'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z')