I am trying to find out wrong email addresses by searching multiple characters. Formulas I applied work separately but I could not find a way to combine them to apply in a single cell. Is there shorter way or can you show me how to combine those.
Search for multiple characters and return true or false



Here's a way using Data Validation. You may be able to adapt the formula to use in a sheet.

Perhaps this:
=OR(COUNT(SEARCH({",",";","^","(",")","&"},LEFT(A1,FIND("@",A1)1)))>0,ISERROR(SEARCH(".",RIGHT(A1,LEN(A1)FIND("@",A1)))))

Here's a way using Data Validation. You may be able to adapt the formula to use in a sheet.
Thank you very much.

Perhaps this:
=OR(COUNT(SEARCH({",",";","^","(",")","&"},LEFT(A1,FIND("@",A1)1)))>0,ISERROR(SEARCH(".",RIGHT(A1,LEN(A1)FIND("@",A1)))))
Thank you very much. It works as expected.

Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!