numerical value of a letter
 

Please help:

In one cell you may have a letter. In another cell I want to use a formula
that returns the numerical value of the letter, e.g. a=1, b=2, c=3 etc.

The formula must not reference to anyother cell except for the one
containing the letter, i.e. this means you cannot use a vlookup.

Can someone please advise? Thanks.

=CODE(UPPER(A1))-64

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Graeme" wrote in message
...
Please help:

In one cell you may have a letter. In another cell I want to use a formula
that returns the numerical value of the letter, e.g. a=1, b=2, c=3 etc.

The formula must not reference to anyother cell except for the one
containing the letter, i.e. this means you cannot use a vlookup.

Can someone please advise? Thanks.