How to convert text "A" to a number using a formula

  • Thread starter Thread starter yakky
  • Start date Start date
Y

yakky

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
 
Back
Top