Excel: advanced filter

I have a column of 5000 job titles, I would like to search the column for any of 20 different words. If it contain any of the 20 words, I will delete them. I see how I can filter up to 2 words using the customer filter and using the word contains. How do I do this for up to 20 words?

This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of August 22, 2014.

For more resources for Microsoft Excel