changing letters to numbers

D

Dimitri

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.
 
P

paul

i am sure it is a little more involved than that,otherwise you could just
change them
do p and b appear in a formula or as a result of a formula,or are they
choices from a list or.....?
 
L

L. Howard Kittle

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
 
Top