Programming Quest is the ultimate destination for programmers seeking solutions to technical questions related to programming languages, software settings, and more. Our blog provides easy-to-understand tips and tricks that will help you take your programming skills to the next level. Discover the power of Programming Quest today!
Pages
▼
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:
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.
No comments:
Post a Comment
If you have any doubts regarding the post. Please let me know.