Regular Expression to Return "True" or False" if a word is found

Hello,

I've been using regular expression in several custom functions to check and correct various things with addresses. I'd like to create one more function that simply returns True or False in the adjacent cell if the cell with the address contains one of several words. One of the problems will be c/o for "care of". It could be anywhere on the line. Not sure how to escape the back slash either.

Please Login or Register  to view this content.

Thank you for your help.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time. --6StringJazzer

You are searching for a static string; regular expressions may not be needed for that. I would suggest the following. Note that I suggest returning a Boolean instead of a string. I don't understand the rules for determining True or False; your current code will always return False because that's always the last line you execute. The code below will return TRUE if the string contains any of the words searched for:

Please Login or Register  to view this content.

If you really want to use regexp because the word boundaries are important (in addresses I don't think they are but you know what you need) then try this:

Please Login or Register  to view this content.

I have not tested this but would be happy to if you provide your test data.