Hi,
I would like to create a macro or excel formula that can verify email addresses in a column.
For example, I need to verify a list with a lot of emails that cannot have any special characters or spaces, just one below each other like these:
john.doe@extension.com
john.doe@extension.com
john.doe@extension.com
john.doe@extension.com
john.doe@extension.com
john.doe@extension.com
And if someone comes up with a list that contains special characters or spaces, the formula/macro could verify and highlight where is the error. I just want to paste the whole list in a column to get it validated.
john.doe@extension.com
john.doe@extension.com
john./doe@extension.com
john.doe@extension.com
john.doe@extension.com
john.doe@extension.com
Let me know if i was clear
Thanks,
I would like to create a macro or excel formula that can verify email addresses in a column.
For example, I need to verify a list with a lot of emails that cannot have any special characters or spaces, just one below each other like these:
john.doe@extension.com
john.doe@extension.com
john.doe@extension.com
john.doe@extension.com
john.doe@extension.com
john.doe@extension.com
And if someone comes up with a list that contains special characters or spaces, the formula/macro could verify and highlight where is the error. I just want to paste the whole list in a column to get it validated.
john.doe@extension.com
john.doe@extension.com
john./doe@extension.com
john.doe@extension.com
john.doe@extension.com
john.doe@extension.com
Let me know if i was clear

Thanks,