I have a large (50k+records) spreadsheet I've been 'cleaning' using some
basic cell functions that look for specific strings and then remove or
substitute, using mostly if(isnumber(search("String", Cell#) and things like
left, right, substitute.

However these are getting kind of long as the lists of words to
remove/replace is getting large.

At it's simplest I'd love to do something that effectively does:

In This Cell
If the String Contains <AnyWordsInThisTable/Row/Etc
Remove that Word

Even Better would be if I had a two column sheet (e.g. WordsSheet) and could
do

If this String Contains Any of the Words in WordSheet:ColumnA
Replace with WordSheet;ColumnB

Ideally in either/both cases I could specify Whole or Partial Word

Any ideas appreciated, my cell formulas are getting quite clunky and hard to
both create and troubleshoot!

Thanks in advance!