| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort e-mail address | Excel Discussion (Misc queries) | |||
| E-mail to every e-mail address in an Excel column? | Excel Discussion (Misc queries) | |||
| forgot my e-mail address | Setting up and Configuration of Excel | |||
| e-mail address formatting | Excel Worksheet Functions | |||
| how do i find my e-mail address & add one more | Setting up and Configuration of Excel | |||
Linear Mode
