What were the results?

What is "did not work"?

Sandy's formula and the shorter one from Dave P. both work for me.


Gord Dibben MS Excel MVP

On Thu, 20 Apr 2006 15:36:02 -0700, 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