View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 380
Default Letters of Alphabet

=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