Delete words within phrase from list of words

I have a list of phrases. I have a second list of specific words that I need to delete (replace with "") from within each phrase. For example;

Phrases
Dogs for sale in Virginia
Dogs in lower Virginia
Virginia dogs sale internet

List of words to delete
Dogs
Internet
Lower
For
etc...

Ultimately reducing the phases to words that are not within the list of words to delete.

Ideally, I would like to do this formula/s as I am not as versed with vba in excel -- but am open to vba if that is the only way to do it.

Can somebody please point me in a direction to research solutions. Thanks

Try this :
=SUBSTITUTE(A1,{"Dogs","Internet","Lower","For"},"")
Replace A1. Add/delete words from the array.

Try this :
=SUBSTITUTE(A1,{"Dogs","Internet","Lower","For"},"")
Replace A1. Add/delete words from the array.

That's what I was afraid of. I fairly good at vba for access but have never used in in excel. Not sure what to do with the code you gave and how to integrate it

Thanks amphinomos. I thought of the substitute command, however; my list of words to delete are not finite to 4 specific words-- the list is over 200 words and I want to have the ability to add to it.

Hmmm. I set it up as you described but it returns #NAME?

Originally Posted by wcymiss

Hi,
you should enable macros.

plz see this:http://m.videojug.com/film/how-to-en...acros-in-excel

I have saved the file as macro enabled and verified that macros are enabled in the trust center. Still no luck though