Thread: How to validate email address during data entry in Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JB JB is offline
external usenet poster
  
Posts: 115
Default 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

Reply With QuoteReply With Quote