Check if cell is an email address

[blommerse]

Goodmorning,

I have a sheet contains names, adresses and email addresses. Which are
filled in by several people.
Is there a possibility to make an pop up if the email address not
filled in correctly, so without an "@" and an "." (row N and Q)
I tried to do this with the validation function.

Hope some specialist can help me with this.
Thanks.

Berry

 

[Bob Phillips]

This formula should do it

=AND(ISNUMBER(FIND("@",N2)),ISNUMBER(FIND(".",N2)))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

In addition to Bob's suggestion, you need to make sure the "." comes after
the @

In it's present form, it can be in front of the @

 

[blommerse]

Thanks a lot Wigi and Bob!!!

Sheers!