How do I convert letters to numbers in Excel?

[scarly123]

I want to convert letters to numbers in Excel such where A=0 , B=1,
C=2,....and on. Help please!!!!

 

[Scoops]

I want to convert letters to numbers in Excel such where A=0 , B=1,
C=2,....and on. Help please!!!!

Hi scarly123

If A is in A1 then in B1 type

=CODE(A1)-65

Regards

Steve

 

[Dana DeLouis]

A=0

Hi. Note that the Asc Code for the letter A is =CODE("A"), or 65.
If A1 has the letter "A", then one way...
=CODE(A1)-65
...e.tc.

 

[Gord Dibben]

All 26 letters or just some letters?

".........and on" is not too detailed.

Do you need this for a grade-point system or similar?


Gord Dibben MS Excel MVP

 

[L. Howard Kittle]

Perhaps you can play with this to do what you want. Enter a in A1 and it
returns 5.

=LOOKUP(A1,{"a","b","c","d","e"},{5,4,3,2,1})

HTH
Regards,
Howard

 

[Pete_UK]

Probably more robust to have:

=CODE(UPPER(A1))-65

Hope this helps.

Pete