View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
L. Howard Kittle L. Howard Kittle is offline
external usenet poster
 
Posts: 698
Default 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!!!!