How do I convert letters to numbers in Excel?

G

Guest

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

Scoops

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

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.
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Convert word into numbers and back 4
Showing Letters For Column Headers Rather Thann Numbers ? 1
Excel coolumn headings changed from A, B, C, etc. to 1, 2, 3 1
Excel Column labels show as numbers 2
Columns are numbers instead of letters 4
Columns now numbers rather than letters how do i get letters back 2
Column headings - urgent help needed please 3
How to convert numbers to corresponding letters? Ex: 123 to abc 4

Top