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.
 
Back
Top