View Single Post
  #1   Report Post  
BethP
 
Posts: n/a
Default Validating email address formatting

Is there an easy formula to tell you if an email address is formatted
correctly, with ? I don't even need to know more than that
(such as valid domains, etc.) for now.

My original thought was just a basic IF statement to drop in to the next
column that tells me if the cell is formatted correctly. But I don't know
how to look for text in a particular sequence or format.

Any ideas for something like this, or better? Thanks!
(You all always have the best answers!)

-bethp

(Inadvertently x-posted to Excel Programming too; sorry for the dupe request!)