Hi
Why don't you create a VLOOKUP.
eg.
Put letters A....D in cells A1 to A26 and numbers in B1 to B26

then use =VLOOKUP(Cell, A1:B26,2, False) to find the number that corresponds
to the letter.

The table can even be put on a different sheet.

HTH
Michael

"2pojeff" wrote:

Hello Sandy

I typed this formula into cell B9 and entered a letter in cell A8 this did
not work.

"Sandy Mann" wrote:

Try:

=IF(A8="","",IF(OR(CODE(UPPER(A8))<65,CODE(UPPER(A 8))91),"Not a
Letter",CODE(UPPER(A8))-64))

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"2pojeff" wrote in message
...
I trying to write a formula where if I input any letter into a cell I want
the adjacent cell to display the alphebtic number of that letter.

Where A=1 B=2 etc etc Z=26

Example.

I put letter d in cell A2 I then want cell B2 to display 4
I put letter z in cell A2 I then want cell B2 to display 26