Thread: Letters and Number formulas
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default Letters and Number formulas
Try this in B2, where A2 contains the letter:

=CHAR(UPPER(A2))-64

Hope this helps.

Pete

Reply With QuoteReply With Quote