Automated filter? Automated replace?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm cleaning up large datafeeds . . .

Can a filter/macro be made to delete rows containing any of a list of words?

Can one also replace a list of spaces and charactors in columns?
 
The answer to both is yes...I suspect the next question is how?

Do you want the theory or what have you tried so far

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
I use Auto Filter on the header row (Panes frozen) and mostly Custom.

Function I need is 'contains', (which is not accessable without scrolling
down the way too short dropdown each time.)

Rows with filter words are deleted or edited.

Lots of / and <, -, >, and spaces to find and replace with Edit->Replace

Check progress with Auto Filter dropdown.

-Steve
 
Back
Top