How do I eliminate bad email addresses from column list?

B

belharris

I have an excel sheet with thousands of email addresses listed down one
column. There are numerous bad emails that are missing the @____ in the
address and we know they will get bounced back. How do I search within this
LONG list for addresses that are missing the @___ part of the address and
delete it so that when we use the list we reduce the bounce backs. Basically
searching for something tht is NOT there and deleting that entry.
 
S

Sheeloo

Suppose you have your addresses in Col A
enter this in B1 and copy down
=FIND("@",A1)

You will get #Value! error for those rows where @ part is missing. You can
filter on #VALUE! and delete those rows...

Similarly you can search for a period...
 
B

belharris

Most Excellent, Thank you!!!!

Sheeloo said:
Suppose you have your addresses in Col A
enter this in B1 and copy down
=FIND("@",A1)

You will get #Value! error for those rows where @ part is missing. You can
filter on #VALUE! and delete those rows...

Similarly you can search for a period...
Click to expand...
 

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

Remove bad addresses 2
Need help comparing & flagging email lists 3
How to extract email addresses from 1 worksheet to another workbook 11
How do I export email addresses from Excel to Outlook? 2
Column of email addresses: how to just use the part before the "@" 1
How do you attach multiple email addresses within different cells 4
Creating emailing list from column of addresses 2
unknown email addresses 2

Top