How to do email validation in Excel?

R

R

ribadima2013-12-17 22:47:01

excel

ribadima, 2013-12-17 22:47:01

How to do email validation in Excel?

It is necessary to do e-mail validation in a column of an excel table. What request should be made for the Data -> Validation function?
download?id=vOIwoDM4XnvA9hFoBlE7wWMOQ

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

2 answer(s)

C

Chalokian, 2013-12-17
@Chalokian

Insert into the formula =IF(FIND("@";A:A);FIND(".";A:A);FALSE), where I have the range of cells to be checkedA:A

R

ribadima, 2014-11-03
@ribadima

This answer doesn't work on mac

Similar questions

C

cyberlain2021-05-06 17:32:16

How to find a word from a list in a table cell and display it? 1Reply

S

smash_wp2017-06-13 12:07:00

Why does Excel automatically convert the letters "I" in the middle of the text to uppercase? 0Reply

O

Oleg2017-06-25 21:35:53

Is it possible to solve an equation using an Excel formula? 1Reply

M

Mikhail Petrov2015-07-17 12:04:53

How to calculate sales forecast with statistics for 2.5 years? 5Reply

D

Dmitry2017-06-27 16:04:11

EXCEL: color green if less than adjacent column - how? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question