How to validate email address during data entry in Excel
 

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

Thank you

How to validate email address during data entry in Excel
 

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

JB
http://boisgontierjacques.free.fr/

On 20 jan, 21:21, Ramiro wrote:
I have an Excel spreadsheet to collect e-mail address. During data entry, how
do I validate an e-mail address entry?

Thank you