Email?
Is it possible to test if a given email addresse is valid, using worksheet
formulas (not macros/UDFs)? What's the formula? CE |
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 |
All times are GMT +1. The time now is 04:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com