How to remove rows that contain a number/word in the cell

[jake.rourke]

Hi,

How can i remove rows that contain a character/word in 1 go.

So for example, anything that has the below in a row:

0,1,2,3,4,5,6,7,8,9,0,plus,griffin

excel help.png

[oeldere]

http://www.excelforum.com/the-water-...ml#post3822723

[bmouse]

Perhaps it would be possible to write a macro that does this, but its not something I can do.

What I would do in this situation is use Conditional Formatting to highlight the cells/rows that contain the specified symbol, word or phrase, then sort the entire data by cell/row color and delete the colored ones.