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