R Ramiro Jan 20, 2009 #1 I have an Excel spreadsheet to collect e-mail address. During data entry, how do I validate an e-mail address entry? Thank you
I have an Excel spreadsheet to collect e-mail address. During data entry, how do I validate an e-mail address entry? Thank you
J JB Jan 20, 2009 #2 =AND(NOT(ISERROR(SEARCH("@",A1))),NOT(ISERROR(SEARCH(".",A1)))) JB http://boisgontierjacques.free.fr/
=AND(NOT(ISERROR(SEARCH("@",A1))),NOT(ISERROR(SEARCH(".",A1)))) JB http://boisgontierjacques.free.fr/
