Search A Range For Specific Text String

Originally Posted by Glenn Kennedy

Hi. If I've understood you correctly, this is what you need.

Yes, and no. It provides the correct result but, I had tried to simplify my example but this may have caused me to give you too little info.

The actual data I will be using has a long text string which will use the word "Communication" in them, but they are not all necessarily the same string. The only one's I want to ignore are those that contain both "Communication" and "Information".

So, for example:
"Department of Communication", "Diploma in Communication" and "Level 4 Certificate in Communication" are all acceptable. "Department of Information and Communication" isn't because it contains the string "Information".