Changing text "A" to a number?

[Larry]

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

 

[Pete_UK]

Try this:

=CODE(LOWER(A1))-96

Then copy down.

Hope this helps.

Pete

 

[JE McGimpsey]

One way:

= CODE(UPPER(A1)) - 64

another:

=MATCH(A1,{"a","b","c"})

 

[Larry]

Thanks!