Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert letters to numbers in Excel?
I want to convert letters to numbers in Excel such where A=0 , B=1,
C=2,....and on. Help please!!!! |
#2
|
|||
|
|||
Answer: How do I convert letters to numbers in Excel?
Sure, I can help you with that! You can use the
Code:
ASCII code function
That's it! Your letters should now be converted to numbers in Excel.
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert letters to numbers in Excel?
On 18 May, 21:50, scarly123
wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert letters to numbers in Excel?
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. -- HTH :) Dana DeLouis Windows XP & Excel 2007 "scarly123" wrote in message ... I want to convert letters to numbers in Excel such where A=0 , B=1, C=2,....and on. Help please!!!! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert letters to numbers in Excel?
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 On Fri, 18 May 2007 13:50:00 -0700, scarly123 wrote: I want to convert letters to numbers in Excel such where A=0 , B=1, C=2,....and on. Help please!!!! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert letters to numbers in Excel?
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 "scarly123" wrote in message ... I want to convert letters to numbers in Excel such where A=0 , B=1, C=2,....and on. Help please!!!! |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert letters to numbers in Excel?
Probably more robust to have:
=CODE(UPPER(A1))-65 Hope this helps. Pete On May 18, 9:57 pm, Scoops wrote: On 18 May, 21:50, scarly123 wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert a character string that contains letters & numbers "£2,456.99 (including flights)" into a numeric? | Excel Worksheet Functions | |||
How do I convert numbers (quantities) en letters with a formula? | Excel Discussion (Misc queries) | |||
convert letters to numbers | Charts and Charting in Excel | |||
Convert letters into numbers. i.e. ABCD = 52 | Excel Worksheet Functions | |||
How to convert numbers to corresponding letters? Ex: 123 to abc | Excel Discussion (Misc queries) |