Pete,

I agree but can't see the other post in this case. Where?

Mike

"Pete_UK" wrote:

Please don't multi-post - you have an answer elsewhere.

Pete

On Apr 11, 5:11 pm, yakky wrote:
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