Letters of Alphabet

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" <[email protected]> wrote in message
news:[email protected]...
> 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)

<[email protected]> wrote in message
news:[email protected]...
>
> 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))