A little short on info but this may help.

=LOOKUP(A1,{"B","P"},{1,2})

Where A1 has a B or P and the formula cell returns 1 or 2.

HTH
Regards,
Howard

"Dimitri" wrote in message
...
I have a group of letters that I would like to change to numbers. namely B
to
1 and P to 2.

Thanks for your help.