Pick / Collect Email ID easily from a wrap text in Excel Sheet

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.