PDA

View Full Version : Validate Email in a Excel Cell



Dorababu
11-24-2011, 08:33 AM
I would like to valid Excel Cell itself by using the Data Validations available. I would like to valid the cell when and only if the user enter a valid Email so can any one help me please

Simon Lloyd
11-24-2011, 08:35 AM
Can you try to explain a little clearer as that makes little sense :)

Dorababu
11-24-2011, 08:38 AM
Can you try to explain a little clearer as that makes little sense :)

Dear Simon,

I would like to Valid an excel cell, to check whether the cell value is in Proper Email ID format or not using the data validations available in Excel.

jaydee
11-24-2011, 01:18 PM
I think he wants to check if the e-mail addresses aren't invalid, like they contain special characters which aren't allowed

i.e.
bob?@hotmail.com <--invalid character
tracy@ hope.com <-- a space after the @

Is that what you're trying to check?

Dorababu
11-24-2011, 10:00 PM
yeah this case too.. If i enter some thing like a and left the cell i would like to give an error message.. Only when proper email id entered i would like to valid that cell.

valid demo@g.com

Invalid : demo@d@d.com, and as per Jaydee said

Rob342
11-28-2011, 12:28 PM
you can only validate the E mail format not the actual e Mail address

refer to this link on KBase

http://www.vbaexpress.com/kb/getarticle.php?kb_id=281

Rob