Automated filter? Automated replace?


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?
 
Ad

Advertisements

N

Nick Hodge

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)
 
Ad

Advertisements

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automation Error 0
Automation Error 0
Automation Error 0
automation error 0
Automation Error 0
Automation error 1
Automation Error 0
Automation Error and Crash 0

Top