How to do email validation in Excel?

R

ribadima2013-12-17 22:47:01

excel

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

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

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