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

Try this in B2, where A2 contains the letter:

=CHAR(UPPER(A2))-64

Hope this helps.

Pete

Nope this did not work

"Pete_UK" wrote:

Try this in B2, where A2 contains the letter:

=CHAR(UPPER(A2))-64

Hope this helps.

Pete

I'd try it again, but use =code()

=CODE(UPPER(A2))-64



2pojeff wrote:

Nope this did not work

"Pete_UK" wrote:

Try this in B2, where A2 contains the letter:

=CHAR(UPPER(A2))-64

Hope this helps.

Pete



--

Dave Peterson

Thanks for the correction, Dave - I rushed it!

Pete

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

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

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

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

2pojeff" wrote in message
... Hello Sandy

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

It works for me - although I would think that it would make more sense if
you typed it into B8 not B9 but it will work in any cell.

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"

Dont'cha just love trying to help with a bit of input, and then getting a nil
response whatsoever from the OP.
We all have a diffrent spin on a question, but it would be nice to know
which way the user goes. Why do we bother !!!

Michael M.

"Sandy Mann" wrote:

2pojeff" wrote in message
... Hello Sandy

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

It works for me - although I would think that it would make more sense if
you typed it into B8 not B9 but it will work in any cell.

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"

<<<"Why do we bother !!!"

Because we enjoy doing it ... with or without any appreciation!

And we realize that many posters are inexperienced with using these NGs, and
therefore are very easily confused and unable to even find their own OPs,
much less carry on any extended conversation with other responders.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Michael M" wrote in message
...
Dont'cha just love trying to help with a bit of input, and then getting a
nil
response whatsoever from the OP.
We all have a diffrent spin on a question, but it would be nice to know
which way the user goes. Why do we bother !!!

Michael M.

"Sandy Mann" wrote:

2pojeff" wrote in message
... Hello Sandy

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

It works for me - although I would think that it would make more sense
if
you typed it into B8 not B9 but it will work in any cell.

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"