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.
