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

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