 # Search for multiple characters and return true or false

• 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.

Code
``````=SUMPRODUCT(--ISNUMBER(SEARCH({",",";","^","(",")","&"},LEFT(A1,FIND("@",A1)-1))))>0
=SUMPRODUCT(--ISNUMBER(SEARCH(".",RIGHT(A1,LEN(A1)-FIND("@",A1)))))=0``````

[SIZE=4]"I don’t pretend we have all the answers. But the questions are certainly worth thinking about."
Sir Arthur C. Clarke
[/SIZE]

• Perhaps this:

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

Rory
Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

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

Thank you very much.

[SIZE=4]"I don’t pretend we have all the answers. But the questions are certainly worth thinking about."
Sir Arthur C. Clarke
[/SIZE]

• 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.

[SIZE=4]"I don’t pretend we have all the answers. But the questions are certainly worth thinking about."
Sir Arthur C. Clarke
[/SIZE]

## Participate now!

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