Macro- Email Address Clean up

Everyday I pull a spreadsheet of demographic data that includes name, DOB, and email address. I upload this spreadsheet to send out mail to all of the email addresses on the list. However, the data is always very dirty and takes hours to clean up. I need help creating a macro to do the clean up for me. The columns and data format never changes, but the amount of rows is always different. 

 

Here are the things i need to clean up.

 

Delete entire row if any columns contain “,”

 

Delete entire row if Email address (column D) contains any special characters (< > / ” ‘ : ; $ # ! % ^ & ( ) )

 

Delete entire row if email address (column D) does not contain @ or “.” 

 

Delete entire row if email address (column D) if contains @@ or ..  (double symbols)

 

Thanks,

By: Philip

Leave a Reply

Your email address will not be published. Required fields are marked *