With your letter in A1, put this in B1 to get the appropriate value:

=MOD(CODE(UPPER(A1))-65,9)+1

There is no error checking beyond catching letters a-z.

Hope this helps.

Pete


On Jul 25, 5:49*pm, MagicBill
wrote:
I am trying to return a number (1-9) for a letter.

For instance:

A * * B * * C * * D

A * * J * * *S * * 1
B * * K * * *T * * 2
C * * L * * *U * * 3
D * * M * * V * * 4
E * * N * * W * * 5
F * * O * * X * * *6
G * * P * * *Y * * *7
H * * Q * * Z * * *8
I * * *R * * * * * * 9

I can do the first column, but when I try the second or third columns, I get
an error value. *So how can I type in a W and get it to return a 5, an I to
return a 9, and so on?