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
|