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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.