Check if cell is an email address

  • Thread starter Thread starter blommerse
  • Start date Start date
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
 
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)
 
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 @
 
Back
Top