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
|