Sharepoint Column E-mail Validation Formula

Sharepoint List Column E-Mail Validation Fromula




=AND(    ISERROR(FIND(" ", [Email],1)), 
IF(ISERROR(FIND("@", [Email],2)), 
FALSE, AND(ISERROR(FIND("@",[Email], FIND("@", [Email],2)+1)),
IF(ISERROR(FIND(".", [Email], FIND("@", [Email],2)+2)),FALSE,FIND(".", [Email], FIND("@", [Email],2)+2) < LEN([Email])))))







Reference

http://thechriskent.com/2012/08/16/validate-email-address-columns-in-sharepoint/