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

need to extract email addresses from excel files 3
Column full of email addresses: how to truncate to just part of eachemail address (before the "@") 2
deleting rows that is compared to a single column. 1
Creating emailing list from column of addresses 2
Pulling a specific email from cells and putting info in new row 4
Column of email addresses: how to just use the part before the "@" 1
How do I generate an email list from my worksheet? 9
Mail and Contacts Clear List 1

Top