G
Guest
I want to convert letters to numbers in Excel such where A=0 , B=1,
C=2,....and on. Help please!!!!
C=2,....and on. Help please!!!!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
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
D
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.
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.
G
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
".........and on" is not too detailed.
Do you need this for a grade-point system or similar?
Gord Dibben MS Excel MVP
L
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
returns 5.
=LOOKUP(A1,{"a","b","c","d","e"},{5,4,3,2,1})
HTH
Regards,
Howard
P
Pete_UK
Probably more robust to have:
=CODE(UPPER(A1))-65
Hope this helps.
Pete
=CODE(UPPER(A1))-65
Hope this helps.
Pete