convert alpha to numeric

[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

 

[Neil]

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!

 

[Brenda]

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!




.