Hello,
Is there an easy way to find the number of a letter in the alphabet; e.g.
that "E" is the fifth letter?

Thanks.

Bill

=CODE(UPPER("E"))-64

I stuck the UPPER in there in case you use a formula to derive E, or a cell
reference, and it might be lower case.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Bill" wrote in message
link.net...
Hello,
Is there an easy way to find the number of a letter in the alphabet; e.g.
that "E" is the fifth letter?

Thanks.

Bill

Bob Phillips wrote:

=CODE(UPPER("E"))-64


Or instead of 64, you could use Asc("A") - 1

Yeah, you could, but ...

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

wrote in message
oups.com...

Bob Phillips wrote:

=CODE(UPPER("E"))-64


Or instead of 64, you could use Asc("A") - 1

If your letter's in A1 then you could use

=COLUMN(INDIRECT(A1&1))


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=555287