Validate an email address

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there an easy formula to tell you if an email address is formatted
correctly, with (e-mail address removed)? I don't even need to know more then 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Validating email address formatting 5
Email Bounce Error 3
Highlight Cell that contains invalid email format 3
Validate an Email Address 1
Excel VBA Replace Data Validation Titles and Input Messages 2
Data Validation blanks for formulas 18
Email address validation 2
Validate IP Address 16

Back
Top