Extract email addresses from mixed data into new column - help please!

Hey there

This is my first ever post - and I have search this site extensively for the answer but none seem to fit correctly to me needs.

I need to extract all email addresses from a column of cells which contain mixed data. The data is not in any set order, and emails are not marked in any way other than having an "@" sign in the middle. All terms are separated by a space at least, be usually with a space-slash-space (" / "). I will try and illustrate below. I'd like the emails listed in a column to the side of my mixed data column please. I'm not great with VBA but have been ok with formulas. The obvious way seems to be to extract any terms with an @ sign in them. Help please. A big thank you in advance

[email protected] / mobile tel / text
cell number / [email protected]
landline tel / cell tel / [email protected]

Try this:

=TRIM(MID(SUBSTITUTE(" "&A1," ",REPT(" ",99)),FIND("@",SUBSTITUTE(" "&A1," ",REPT(" ",99)))-20,99))

The example text above is all in the one column, and the emails never have hyperlinks - Cheers

Hey Mama - thank you so much!

Perfect. Works really well and has saved me hours of work. Thanks for such a positive and rapid response to my first ever post

Mama really does know best

Thanks again

You're Welcome!