Hi maryj
if it finds "apples" do you want "apples" in B1; if it finds "oranges" do
you want "oranges" in B1 etc?
If so then one option is
=IF(ISERR(SEARCH("*CP*",A1)),IF(ISERR(SEARCH("*app les*",A1)),IF(ISERR(SEARCH("*oranges*",A1)),IF(ISE RR(SEARCH("*bananas*",A1)),IF(ISERR(SEARCH("*grape s*",A1)),"","grapes"),"bananas"),"oranges"),"apple s"),"CP")
Cheers
JulieD
"maryj" wrote in message
...
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
|