Is there a formula or function that deletes a set of words?

[jtmann]

I'm looking to create a template that I paste data into but there are so many unnecessary words/cells.

Find and replace and deleting cells is so time consuming.
Please see attached, as I have no idea how to explain my query with only words.

[Logit]

Please Login or Register  to view this content.

http://stackoverflow.com/questions/9...based-on-color

[jtmann]

The color of the cells was simply to clarify which cells. I need to delete all cells that contain the words "Bottle", "Preservative Test Code", "# of containers to fill per sample", "Test Code" and "Preservative"

[FDibbins]

Formulas can only affect the cell they reside in, then cannot do anything to any other cells
You would need VBA for that

[Logit]

Would "FIND AND REPLACE" (HOME tab, Find & Select) do the job ?

No need for VBA.

[Logit]

This macro will search the entire sheet and clear the cells containing the terms in fndList

Please Login or Register  to view this content.

[FDibbins]

Would "FIND AND REPLACE" (HOME tab, Find & Select) do the job ?

No need for VBA.

From the 1st post on this....

Find and replace and deleting cells is so time consuming.

[Logit]

But effective !

[FDibbins]

Indeed, until there are dozens (or more) that you need to do

[Logit]

Its only time .....

[FDibbins]

indeed, but the more it needs to be done, the greater the chance of an error creeping in. Plus, if this is a regular task (daily, weekly or monthly), it can become onerous and frustrating

[Logit]

Ok .... "uncle" .... you win.

[FDibbins]

Wasnt a contest was an interesting discussion on the merits of manual vs automated - and you gave some good code to do that

[Logit]

Thanks ! Appreciate the compliment.

* uncle *