ExcelBanter - Validation on E-mail address

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Validation on E-mail address (https://www.excelbanter.com/excel-worksheet-functions/134782-validation-e-mail-address.html)

Peter Adema

Validation on E-mail address

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

Thanks for your support.

Teethless mama

Validation on E-mail address

Data Validation

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

"Peter Adema" wrote:

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

Thanks for your support.

Peter Adema

Validation on E-mail address

Yes, that's the good one.

Thanks teethless.....

"Peter Adema" wrote:

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

Thanks for your support.

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