Check if cell is an email address

B

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
 
B

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)
 
W

Wigi

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 @
 
Top