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)



By: Philip

562 thoughts on “Macro- Email Address Clean up

  1. App De Tv Pago

    Ponto IPTV a melhor programacao de canais IPTV do Brasil, filmes, series, futebol, lutas, shows, documentarios em alta definicao de imagem e som em SD, HD, FULL HD, 4K. compativel com todos aparelhos do mercado Brasileiro.

Comments are closed.