How do I search Strings and get an output?

[dziw]

Using MS Excel 2003

Hello,

I have the following text in cells:

A1: lobster and drink
A2: steak and wine
A3: bacon and eggs
A4: dinner plate and water
A5: lunch plater
A6: sandwich and drink

I want excel to look for certain words in these strings and "categorize" the string.
So I'm trying to get excel to look at these strings, and if they contain the words: "lobster", or "steak" or "dinner" I want it to output the word "supper" in adjacent cell.

If it contains "eggs" then the word "breakfast" should appear,

And if there's the word "sandwich" or "lunch" the word "lunch" should appear

therefore, after i run this script / use this formula i would get the following result

A1: lobster and drink
A2: steak and wine
A3: bacon and eggs
A4: dinner plate and water
A5: lunch plater
A6: sandwich and drink

B1: supper
B2: supper
B3: breakfast
B4: supper
B5: lunch
B6: lunch

I'd really appreciate any help that anyone could provide!

[jindon]

try

=If(Sum(CountIf(A1,{"*lobster*","*steak*","*dinner*"})),"Supper",If(CountIf(A1,"*egg*"),"Breakfast",If(Sum(CountIf(A1,{"*lunch*","*sandwich*"})),"Lunch","")))

[dziw]

try

=If(Sum(CountIf(A1,{"*lobster*","*steak*","*dinner*"})),"Supper",If(CountIf(A1,"*egg*"),"Breakfast",If(Sum(CountIf(A1,{"*lunch*","*sandwich*"})),"Lunch","")))

Thanks!! that worked perfectly! I really don't understand what is going on...but it works! hurray!

Thanks again!