| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I eliminate bad email addresses from column list?
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I eliminate bad email addresses from column list?
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... "belharris" wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I eliminate bad email addresses from column list?
Most Excellent, Thank you!!!!
"Sheeloo" wrote: 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... "belharris" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel list of names, addresses and email to address book/contact list??? | Excel Discussion (Misc queries) | |||
| can I copy a column of email addresses, paste into email address? | New Users to Excel | |||
| import email addresses into an excell list | New Users to Excel | |||
| Move a Column of 500 Email Addresses into BCC Field of an Email | Excel Worksheet Functions | |||
Linear Mode
