How to Validate Email Entry In A Column Using Column Validation In SharePoint

So you have created a column to collect email addresses in a SharePoint list and you want to validate that only properly formed email addresses are entered by users?

This is what you have to do;

·       Go to the “List Setting”

·       Under “List Setting” go to the “Columns” section and click on the column you will like to validate

·       On the column page locate the “Column Validation” section expand it if it is collapsed and paste the following into the formula text box

=(LEN(LEFT([Employee Email],FIND("@",[Employee Email])-1))>0)+(LEN(RIGHT([Employee Email],LEN([Employee Email])-FIND(".",[Employee Email],FIND("@",[Employee Email]))))>0)+(LEN(MID([Employee Email],FIND("@",[Employee Email])+1,FIND(".",[Employee Email],FIND("@",[Employee Email]))-FIND("@",[Employee Email])-1))>0)+(ISERROR(FIND(" ",[Employee Email]))=TRUE)=4

·       And enter the appropriate validation error message into the “User Message” text box

·       That’s it your column is validated!!!