Letters and Number formulas

2

2pojeff

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
 
P

Pete_UK

Try this in B2, where A2 contains the letter:

=CHAR(UPPER(A2))-64

Hope this helps.

Pete
 
2

2pojeff

Hello Sandy

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

Michael M

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
 
G

Gord Dibben

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
 
S

Sandy Mann

2pojeff said:
I typed this formula into cell B9 and entered a letter in cell A8 this did
not work.
Click to expand...

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

[email protected]
[email protected] with @tiscali.co.uk


"
 
M

Michael M

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.
 
R

Ragdyer

<<<"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.
 
K

Ken Johnson

Hi Ragdyer,
I'm still struggling with some of the acronyms. My kids are always
ribbing me about it!
OP=?

Ken Johnson
 
D

Desert Piranha

Ken said:
Hi Ragdyer,
I'm still struggling with some of the acronyms. My kids are always
ribbing me about it!
OP=?

Ken JohnsonHi Ken,
Click to expand...
I believe "OP" = "Original Post
 
K

Ken Johnson

Hi Desert Piranha,

Thanks for that, it makes more sense then "Other Person" or
"Operational Problem":)

Ken Johnson
 
M

Michael M

Hi RD
You're absolutely right, of course.
I guess the good old days of thanks are long gone....I must be getting old.
But I dooo enjoy doing it all the same

Michael M
 
R

RagDyeR

Depending on context, it refers to either:

Original PostER
OR
Original Post
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

Hi Desert Piranha,

Thanks for that, it makes more sense then "Other Person" or
"Operational Problem":)

Ken Johnson
 
K

Ken Johnson

Hi Gord and RagDyer,
Thanks for that.
My kids will not be so amused now.
Ken Johnson
 
Top