Any Excel Guru's here?

welshman said:

I've been racking my brain, but can't think of how to do this. I have a new process in place that will save me a bit of money, and I need to clean a few of my old email lists. I have an email list cleaner, but it only lists the valid emails in the list if I paste it into my webpage.

Is there a way to receive the cleaned data back and remove the invalid records from the master list? I'd normally just be able to copy the valid emails into another list, but a few of them contain other data such as first name, business, opt-in IP address and date, etc, so I don't want to lose this.

Or alternatively, is there a way to bulk remove the valid emails from the list, then I could load up all the invalid emails into my blacklist.

Click to expand...

reuse said:

Tweaking the first method listed here may work for you: https://www.extendoffice.com/documents/excel/4076-excel-exclude-one-list-from-another.html
(Not my site, nor of anyone I know)

Click to expand...

tubeboost said:

As an alternative way is to use editors like notepad++ and regex. But you need to learn regex. It could take time.

Click to expand...