Validation on E-mail address

[Peter Adema]

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 "[email protected]"
What is the formula for that?

Thanks for your support.

 

[Teethless mama]

Data Validation

=ISNUMBER(SEARCH("*@*.*",A1))

 

[Peter Adema]

Yes, that's the good one.

Thanks teethless.....