Showing posts with label email format check in excel. Show all posts
Showing posts with label email format check in excel. Show all posts

Checking format of Email address in excel

Checking email addresses in bulk if the format is correct or not

So in your excel sheet if emails are in A column, go in the B column or other and as per column name put alphabet and row number like B1 cell and copy paste this code: 

=AND(NOT(ISERROR(FIND("@",A1))),NOT(ISERROR(FIND(".",A1))),ISERROR(FIND(" ",A1)))

In formula you can see A2 because A1 is occupied with head column of excel data, After that drag mouse down from B2 it will automatically change the cell row number in formulas or you can copy and paste the code to the other cells. But with respective rownumbers change i.e.

=AND(NOT(ISERROR(FIND("@",A1))),NOT(ISERROR(FIND(".",A1))),ISERROR(FIND(" ",A1)))

 For all the valid e-mails, it will give you ‘TRUE’ and for the invalid ‘FALSE’.

email_validation