Email?
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
|