Finding 2 or More specific words in a sentence inside a Cell in Excel 2007

**gopal22** · 05-18-2010, 07:48 AM

Hi All,
I just registered couple of hours ago and this is my first post.

My Column A contains person's name and a title of that person

Example:
Column A
(Cell 1) Abraham John Mr.
(Cell 2) Jones Patricia Mrs.
(Cell 3) Baldwin Gloria Ms.
(Cell 4) Thomas Reggie

In Column B I want a formula which would search for Mr. Mrs. and Ms. and If it finds any of the three words, then it should return as true or it should return false.

I know this can be done using the find command but I am not able to nest it properly and use it to find all the three words in 1 cell.

So the output for the first 3 cells of Column A would be True and for Cell 4 would be false.

Hope I am not confusing you guys and it makes some sense.

Any help in this regard would be much appreciated Guys!!

Thanks in Advance!!

Have a Great Day!!

Regards,
Gopal.

**DonkeyOte** · 05-18-2010, 07:54 AM

Various options, one might be:

=ISNUMBER(LOOKUP(9.99E+307,--SEARCH({"Mr.","Mrs.","Ms."},A1)))
copied down

(swap SEARCH for FIND if you wish for Mr. <> mr. )