View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
yakky yakky is offline
external usenet poster
 
Posts: 2
Default How to convert text "A" to a number using a formula

In cell A1 I have the either Letter a, b or c.
I would like to give them a numerical value of 1, 2 and 3 in the
adjacent cell.
Can someone post or point me to the formula?
Thanks