How do you search for whole words within cell to return true/false values?

**pearljam007** · 02-17-2011, 09:54 PM

I have two columns:

Column A1:A250 contains one word (e.g. a, an, but, etc) per cell for each of the 250 cells.

Column B1:B800 contains one text phrase (e.g. i am tall, i am a person, etc) per cell for each of the 800 cells

I am trying to determine if each text phrase in Column B contains any WHOLE word from Column A.

So in my example above, the sentence "i am tall" would return a False value since the sentence ""i am tall" does not contain any of the WHOLE words from column A (e.g. a, an, but). Assume for this example that Column A also does not contain the words "I," "am," or "tall" either.

On the other hand, "I am A Person," would return the value True since this sentence contains the whole "a" in Column A.

Also, if a phrase from Column B contains more than one word from Column A, it does not need to count the number of instances ... it simply needs to return the value True to indicate that at least one of the words from Column A is contained within the word from Column B.

Thanks for your help!

**Ron Coderre** · 02-17-2011, 10:00 PM

Welcome to the forum.
I'll have to insist that you click the Forum Rules link at the top of the page and read the rules. You'll notice that we do not allow posting the same question to multiple forums without at least posting a link to the other forums.

I just came from the other forum where I responded to this same question from you. I'll post the link for you *this time*, out of courtesy to our excellent forum members.
This question at MS Answers