Letters of Alphabet

[Bill]

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]

=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)

 

[ektimo]

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

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

 

[Bob Phillips]

Yeah, you could, but ...

--
HTH

Bob Phillips

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

 

[daddylonglegs]

If your letter's in A1 then you could use

=COLUMN(INDIRECT(A1&1))