| Home |
| Search |
| Today's Posts |
|
#12
|
|||
|
|||
you're welcome and thanks for the feedback
"maryj" wrote in message ... Perfect!! That's just what I needed. "JulieD" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Report Using IF Statement? | Excel Discussion (Misc queries) | |||
| IF Statement with Average Function results in #Value! | Excel Discussion (Misc queries) | |||
| when writing an IF statement what is the syntax for "Not Equal to. | Excel Discussion (Misc queries) | |||
| Combining SUM Function with Nested If Statement | Excel Discussion (Misc queries) | |||
| Macro and If Statement | Excel Discussion (Misc queries) | |||
Threaded Mode
