View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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