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



No comments:

Post a comment

If you have any doubts regarding the post. Please let me know.