This is what I need except I needed it nested for several text possibilities.
For example, I need it to find "apples", "oranges", "bananas" or "grapes". I
need the wildcards because these words could be anywhere in a cell.

"RagDyer" wrote:

Try this:

=IF(ISERR(SEARCH("*CP*",A1)),"","CP")

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"DME" <craigjoseathotmaildotcom wrote in message
...
IN cell a1 I have CP-Barge

In B1 I want a formula that says IF A1 contains CP then Enter CP into cell
B1otherwise leave it Blank

I have tried =IF(a1="*CP*","CP","") but it does not work.

Thanks for your help