Excel 2007 : Identify a word in random strings in a column and mark adjacent Column true or false.

Identify a word in random strings in a column and mark adjacent Column true or false.

I have a long list of trade names in a column.(36000)
CHINA CHEF
CHINA CHINA
CHINA CITY II RESTAURANT

I would like to be able to identify all those which have a certain word in this case Restaurant. (not case sensitive). And then show them up in an adjacent column. Like below.
CHINA CHEF FALSE
CHINA CHINA FALSE
CHINA CITY II RESTAURANT TRUE

Excel can do this because I can identify all the cells using find and replace. My objective is to be able ot remove all those that have certain words as they are not what I am looking for. Any assistance would be great. Sadly though I have gone through on line linda’com courses I have a long way to go. I do not mind how I achieve the above.

Here’s hoping to hear from you
All the best
Mark

Wow that was fast. Thanks works great. I tried to add a second word inside a second set of ". Just messed it up. I have about 10 words so I can easily repeat your formula over 10 columns. but just advance my knowledge a little further is there a way to add more than one word.

Solved thanks. Your help has been enormously appreciated. Thanks again
Mark