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))