Extract multiple emails from a single string

[fapb48]

Hello,

I need to extract the emails that are on a single string into separate columns but not sure how to accomplish this.

Example of the string: aa@aa.com##Receive, Deliver;bb@bb.com##Receive, Deliver;cc@cc.com##Receive, Deliver

I know how to retrieve aa@aa.com and bb@bb.com using textbefore and textafter but not sure how to retrieve the third email.

Any help would be much appreciated it.

Thank you

 

[Peter_SSs]

Is this what you want then?

24 01 04.xlsm
	A	B
1	: aa@aa.com##Receive, Deliver;bb@bb.com##Receive, Deliver;cc@cc.com##Receive, Deliver	aa@aa.com
2		bb@bb.com
3		cc@cc.com
emails

Cell Formulas
Range	Formula
B1:B3	B1	=LET(ts,TEXTSPLIT(A1,,{",","#"," ",";"}),FILTER(ts,ISNUMBER(FIND("@",ts)),""))
Dynamic array formulas.

 

[fapb48]

Is this what you want then?

24 01 04.xlsm
	A	B
1	: aa@aa.com##Receive, Deliver;bb@bb.com##Receive, Deliver;cc@cc.com##Receive, Deliver	aa@aa.com
2		bb@bb.com
3		cc@cc.com
emails

Cell Formulas
Range	Formula
B1:B3	B1	=LET(ts,TEXTSPLIT(A1,,{",","#"," ",";"}),FILTER(ts,ISNUMBER(FIND("@",ts)),""))
Dynamic array formulas.

This is great, thank you!

Is there anyway that this can be somehow converted into columns instead of rows? As i have 1000' of rows of emails and need to auto fill the formula for all rows and it will spill..

Sorry, i probably should have mentioned that beforehand..

Thanks

 

[Peter_SSs]

Do you mean like this?

24 01 04.xlsm
	A	B	C	D
1	: aa@aa.com##Receive, Deliver;bb@bb.com##Receive, Deliver;cc@cc.com##Receive, Deliver	aa@aa.com	bb@bb.com	cc@cc.com
emails (2)

Cell Formulas
Range	Formula
B1:D1	B1	=LET(ts,TEXTSPLIT(A1,{",","#"," ",";"}),FILTER(ts,ISNUMBER(FIND("@",ts)),""))
Dynamic array formulas.

 

[fapb48]

Do you mean like this?

24 01 04.xlsm
	A	B	C	D
1	: aa@aa.com##Receive, Deliver;bb@bb.com##Receive, Deliver;cc@cc.com##Receive, Deliver	aa@aa.com	bb@bb.com	cc@cc.com
emails (2)

Cell Formulas
Range	Formula
B1:D1	B1	=LET(ts,TEXTSPLIT(A1,{",","#"," ",";"}),FILTER(ts,ISNUMBER(FIND("@",ts)),""))
Dynamic array formulas.

This is perfect!

Thank you very very much for your help

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.