How to validate email address during data entry in Excel

Ramiro · Jan 20, 2009

I have an Excel spreadsheet to collect e-mail address. During data entry, how
do I validate an e-mail address entry?

Thank you

JB · Jan 20, 2009

=AND(NOT(ISERROR(SEARCH("@",A1))),NOT(ISERROR(SEARCH(".",A1))))

JB
http://boisgontierjacques.free.fr/