Formulas‎ > ‎Formulas‎ > ‎

Extract email address from sentence in cell

posted Mar 26, 2011, 7:11 AM by Ayush Jain   [ updated Jun 11, 2011, 10:52 AM ]
Recently I wanted to extract email address from the sentence given in the cell.
I got the below formula perfectly working to get this done.

EXAMPLE :

1) Hello, abc@abc.com is my email address = abc@abc.com
2) send the ebook at this address  xyz@discussexcel.com = xyz@discussexcel.com

Formula is :
=TRIM(RIGHT(SUBSTITUTE(LEFT(A1,FIND("@",A1)-1)," ",REPT(" ",99)),99))&MID(A1,FIND("@",A1),FIND(" ",A1&" ",FIND("@",A1))-FIND("@",A1))

Comments