Is it possible to test if a given email addresse is valid, using worksheet
formulas (not macros/UDFs)?

What's the formula?


CE

Hi Charlotte,

Am Sun, 29 Sep 2013 19:27:57 +0200 schrieb Charlotte E.:

Is it possible to test if a given email addresse is valid, using worksheet
formulas (not macros/UDFs)?

it is easier with regex or UDF.
With formula you have to check the not valid characters, the "@" and the
domain.
Enlarge the formula for your searched domains:
=((COUNT(FIND({"°";"^";"!";"""";"§";"$";"%";"&";"/";"(";")";"=";"?";"{";"[";"]";"}";"\";"*";"+";"~";"'";"#";";";",";":";"<";""; "ä";"ö";"ü"},A1))=0)*(FIND("@",A1)0)*(COUNT(FIND( {".com";".org";".de"},A1))0)=1)



Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2