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.