ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Validate an email address (https://www.excelbanter.com/excel-programming/334333-validate-email-address.html)

BethP

Validate an email address
 
Is there an easy formula to tell you if an email address is formatted
correctly, with ? 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

BethP

Validate an email address
 
Sorry all- I meant to post in Worksheet Functions... I'll re-post this over
there...



All times are GMT +1. The time now is 04:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com