Extract email addresses between words in a cell

Hi All,

I have been having troubles researching trying to find a solution to my issue below:

As a result of a custom data report run, I have a set of emails that are enclosed within other words in one column. I was hoping to ask here if there was a way I could extract just the email addresses out? - I have attached a sample workbook.

sample_steve.PNG



Many Thanks for any help received.

Cheers -Steve.

In E4

Formula:

Please Login or Register  to view this content.

and drag down

Kind regards
Leo

Originally Posted by Bo_Ry

Please try at E4

=MID(LEFT(D4,LEN(D4)-3),FIND(LEFT(D4,FIND(" ",D4)-1),D4,2),50)

This is fantastic! Works as needed. I just have one future-proofing question, if the original email appears as for example:

John [email protected]

Is there something I could add into your current formula to cater for such anomalies?

If not, as is will do for now.

Thank you so much.

Originally Posted by LeoTaxi

In E4

Formula:

Please Login or Register  to view this content.

and drag down

Kind regards
Leo

Thank you Leo for this. This one seems to most of what I asked initially, just the last letters on the end need to come off after the domain name. Thanks again for helping out!

Originally Posted by Bo_Ry

Try

=MID(LEFT(D4,LEN(D4)-3),FIND(" ",D4)+1+MATCH(TRUE,INDEX(CODE(MID(D4,FIND(" ",D4)+ROW($A$2:$A$20),1))<91,),),50)

Thank you Bo_Ry!! This is works perfectly!!

Once again, thank you for your help