convert alpha to numeric

  • Thread starter Thread starter Brenda
  • Start date Start date
B

Brenda

I'm sure there is a function to do this...

I need to convert "A" to "1", "B" to "2", "C" to "3", and
so on

Thanks for your help,
Brenda
 
Hi

One way -
=CODE(A1)-64
where A! contains A - this will take the ASCII code for A (65), deduct 64
and leave you with 1.

Probably a better way somewhere.

Regards

--
Neil

Yesterday is a memory
Tomorrow is but a vision
Today is just a bitch!
 
Neil:

THANKS!
-----Original Message-----
Hi

One way -
=CODE(A1)-64
where A! contains A - this will take the ASCII code for A (65), deduct 64
and leave you with 1.

Probably a better way somewhere.

Regards

--
Neil

Yesterday is a memory
Tomorrow is but a vision
Today is just a bitch!




.
Click to expand...
 
Back
Top