Hi,
I came across this formula that validates an email address:
=AND(FIND("@",A1),FIND(".",A1),ISERROR(FIND(" ",A1)))
It works fine if the "@" or/and dot is missing but it doesn't check for these rules:
- the "@" comes 1st then the dot,
- the "@" and the "." are separated (don't come together)...