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)