Excel tips and tricks. Data validation. Only email I'd enter in email I'd column in excel
=IF(AND(ISNUMBER(FIND("@",A1)),ISNUMBER(FIND(".",A1,FIND("@",A1)+2)),LEN(A1)-LEN(SUBSTITUTE(A1,"@",""))=1), "Valid email ID", "Invalid email ID")
In place of A1 type your first cell address of the column