Extract part of cell contents

Hello all

Lets say I have a column with each cell containing a bunch of emails, delimited with #, like this:
[email protected]#something...domdomain5.com

There is no specific order in the emails and I am only interested in emails with a specific domain (after the @), in this case, the "@correctdomain.com" emails, ie the [email protected] email.

So in short, I would like to extract the @correctdomain.com emails from column A to Column B, if any exist, as this:
2019-02-16_18-52-33.png

Is there a clever way to do this, or is it just the hard way with multiple nested IF's, FIND's, LEFT's, IFERROR etc?

Thanks in advance

Thank you very much Bo_Ry - this does seems to do the trick and I can use it.

In my actual setup I do have around 8.000 rows, not starting from row 1, and for some reason it does not work if I change $A$1:$A$10 in the code to $A$3000:$A$11000. It only works if it starts at $A$1 or if I do the whole column like A:A. So it does take a very very long time to calculate (like 10 minutes).

Would naturally prefer if I could make the formula less time consuming, but as I said, it works as intended and in lack of something faster I can use it

So again, thanks and I really do appreciate your effort!

I will however keep the thread open for a couple days, in case anyone else should have a more efficient solution.

@Bo_Ry, I totally misunderstood that ROW($A$1:$A$10) thing, I changed it back and now its runs very fast - we are talking seconds now!

@AlKey, this even seems a little more efficient, so I think this is what I will end up using

@MarvinP, yes, I am aware of the powers in PQ, just never really had the time to look much into it - I will definitely look into you solution at a later point and get familiar with it. The above solutions work in my setup for now.

I thank each and everyone one of you for your solutions and effort!

Thanks AliGW, I will note that book down.