you have a better brain than mine.

Thanks, exactly what I was looking for

@Computergaga

10 ай бұрын

Glad I could help.

Michael, You have one to many ) in the formula. Remove one and try again.

Thank you for the video but one can use the following updated formula [2018] =AND(NOT(ISERROR(VLOOKUP("*@*.*",A2,1,FALSE))),ISERROR(FIND(" ",A2)))

Nice video, but this only checks if the format of the email address is correct, not if the email address actually exists, which is the main cause of spam reports/bouncebacks.

@nikolastojanovic1461

7 жыл бұрын

Do you know how to check if email exist?

@jimcarter4343

6 жыл бұрын

you can clean the list from email validation provider. www.accuwebhosting.com/blog/top-10-bulk-email-list-verification-validation-services-compared/

=AND(FIND(“@”,AA6),Find(".",AA6),ISERROR(FIND(" ", AA6)))) when I input this I got an error that is not allowing me to input this in execl

H