Thread: Letters and Number formulas
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
2pojeff
 
Posts: n/a
Default Letters and Number formulas
Nope this did not work

"Pete_UK" wrote:

Try this in B2, where A2 contains the letter:

=CHAR(UPPER(A2))-64

Hope this helps.

Pete


Reply With QuoteReply With Quote