VBA Remove Noise Words from String

[manofcheese]

I have this code that Sa Dq provided for me. I am now looking for a way to make this function refer to a range with a list of noise words and then remove those words from the title.
For example:
The following noise words would be in a list in cells A1:A4
Ounces,
Pound,
Fl,
oz,

Then I would have another cell that contained the title for an item. Lets say this is cell C1
"Big10 Apple Juice 12 ounces"
I would then have the function RemoveNumbersFromString(C1,A1:A4) and the result would be
"Big10 Apple Juice"

Please Login or Register  to view this content.

Does anyone know what I could do to make this code function the way I described above?

[stnkynts]

There might already be default functions to do this but I am not that good with the default functions. Here is a UDF as requested:

Please Login or Register  to view this content.

[manofcheese]

Thanks for the quick reply. I just tested it out but I can't get it to work. In a cell I put the function RemoveWordsFromString(A1,B1:B10). One of the noise words in the list was "ounce" and it didn't remove it from the title. Is there something I could do to change it to make the function work?

[stnkynts]

Hmm. It works for me. Submit your example workbook.

Note: It is case sensitive so that might be causing you an issue

[manofcheese]

It looks like it worked. Is there a way to make it not case sensitive? Also, is it possible to have it take out the noise words only if it is a complete word. For example. Lets say "and" is one of the noise words I want to get rid of and "Band" is one of the words in the title. Currently the function just leaves "B" when i would like it to say "Band". Is there an adjustment that would work for this?

[stnkynts]

Please Login or Register  to view this content.

[SamT]

Please Login or Register  to view this content.

Please Login or Register  to view this content.