Sometimes, it happens that we need to collect Email ID or web address from a cell which contains many data. It is hard to copy & paste them in another cell.
We can collect Email ID or web address (URL) or Mobile number from those cell within a second by using this excel formula. Today I have used it. It saves time.
Step-1: Open your desire excel sheet. Here is an example:
Step-2: Now write down this formula in B2 cell or copy-paste this formula from here & click Enter button & then you will see an Email ID collected from wrap text of this excel cell. See screenshot:
=TRIM(RIGHT(SUBSTITUTE(LEFT(A2,FIND("@",A2)-1)," ",REPT(" ",99)),99))&MID(A2,FIND("@",A2),FIND(" ",A2&" ",FIND("@",A2))-FIND("@",A2))
Step-3: Now grab this formula all over the cell you want to grab Email ID. See screenshot:
Step-4: Finally you will get all the data/Email ID, like that...
I hope that this formula will help us in future to work easily.
Have a great day.
Enjoy.
We can collect Email ID or web address (URL) or Mobile number from those cell within a second by using this excel formula. Today I have used it. It saves time.
Step-1: Open your desire excel sheet. Here is an example:
Step-2: Now write down this formula in B2 cell or copy-paste this formula from here & click Enter button & then you will see an Email ID collected from wrap text of this excel cell. See screenshot:
=TRIM(RIGHT(SUBSTITUTE(LEFT(A2,FIND("@",A2)-1)," ",REPT(" ",99)),99))&MID(A2,FIND("@",A2),FIND(" ",A2&" ",FIND("@",A2))-FIND("@",A2))
Step-3: Now grab this formula all over the cell you want to grab Email ID. See screenshot:
Step-4: Finally you will get all the data/Email ID, like that...
I hope that this formula will help us in future to work easily.
Have a great day.
Enjoy.
No comments :
Post a Comment