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