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!!!! |
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. |
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 |
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!!!! |
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!!!! |
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!!!! |
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 |
All times are GMT +1. The time now is 08:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com