Andy,
A couple of questions if I may,
1. I have another similar situation that I tried to modify your formula to
accomplish with no luck. This time it is text converted to text. Ex "P001"
or "P002" = "SPER", "P004" or "P005" = "MPER" and "P102" = "MH".

Also can you tell me what the *means in the formula you gave me.
Thanks,
--
slh


"Andy B" wrote:

Pleased to help and thanks for the feedback!

--
Andy.


"slh" wrote in message
...
Thanks Andy,
The formula to list them in an adjacent column worked perfectly.
--
slh


"Andy B" wrote:

Hi

To do them in situ, you would need a macro, or use Find/Replace 4 times.
To do them in an adjacent column, you could use something like:
=((A2="BV")*5)+((A2="BR")*4)+((A2="FM")*6)+((A2="F R")*1)
Hope this helps.

--
Andy.


"slh" wrote in message
...
I have a field that can contain one of four different text values, BV,
BR,
FM, FR. I need to convert these to a number, Ex: BV=5, BR=4, FM=6 and
FR=1.
Can I do this with one formula?
--
slh