Validation on E-mail address

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

Guest

I have read different questions, but I have not see the solution to my problem.
I want to validate in one cell if an valid E-mail address has been entered.
With Date validation->Allow custom, I entered the formula (B5;"??@?.?")
So I want a value like "(e-mail address removed)"
What is the formula for that?

Thanks for your support.
 
You must log in or register to reply here.

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

If formula and Data Validation parallely 1
custom data validation on cells with data validation values 2
Data validation for specific text, for example "blue"? 1
validate date entered 3
Data Validation - Complex Q 2
need qualifier statement 10
Sources Used in Data Validation 4
Multiple data validation criteria? 1

Back
Top