how to match random letters to numbers

[47redlands]

I have a column lets call it A, in column A there is 9 random letters A to I e.g.
I
E
D
H
F
A
c
B
G

in column B I wish to have numbers that match the random letters from column A, e.g. A = 1, B = 2,
How can I do this?

 

[SkipVought]

Hi,

=CODE(A1)-64

...assuming that your data starts in A1.

Copy down.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[mintjulep]

Or a bit more robustly,to account for the accidental lower case "c" in the list:

=CODE(UCASE(A1))-64