Distribution linst - Extract emails

[Fran10]

I created a formula to extract email's from a distribution list, but unfortunately the formula dont get update when user is using an apple computer.
Any thoughts on this? Or maybe somebody has another formula that could help me.

Thanks..

The distribution list can have until 400 emails.
see example below:

Distribution list:
Shurtliff, Scott <Scott.Shurtliff@IRIWorldwide.com>; Weidner, Erin <Erin.Weidner@iriworldwide.com>; Stuart, Gail <Gail.Stuart@iriworldwide.com>; Gregozeski, Brian <Brian.Gregozeski@iriworldwide.com>; Rosenthal, Michael <Michael.Rosenthal@IRIWorldwide.com>; Simon, Macee <Macee.Simon@IRIworldwide.com>; Nann, Andreas <Andreas.Nann@iriworldwide.com>

=SUBSTITUTE(FILTERXML("<x><y>"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"<","#"),">","#")," ",";"),";","</y><y>")&"</y></x>","//y[contains(.,'#')]"),"#","")

 

[Fluff]

Do you have the new TEXTSPLIT function?

 

[Fran10]

When the user has a apple computer and past a "new" distribution list, the extract results return an error.
Formula below:
=SUBSTITUTE(FILTERXML("<x><y>"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"<","#"),">","#")," ",";"),";","</y><y>")&"</y></x>","//y[contains(.,'#')]"),"#","")

 

[Fluff]

The filterxml function does not exist on a mac. Can you answer my question.

 

[Fran10]

I have TEXTSPLIT function in my excel, but I dont know if it's the "new" one.

 

[Fluff]

Yes it is.
How about

Fluff.xlsm
	A
1
2	Shurtliff, Scott <Scott.Shurtliff@IRIWorldwide.com>; Weidner, Erin <Erin.Weidner@iriworldwide.com>; Stuart, Gail <Gail.Stuart@iriworldwide.com>; Gregozeski, Brian <Brian.Gregozeski@iriworldwide.com>; Rosenthal, Michael <Michael.Rosenthal@IRIWorldwide.com>; Simon, Macee <Macee.Simon@IRIworldwide.com>; Nann, Andreas <Andreas.Nann@iriworldwide.com>
3
4	Scott.Shurtliff@IRIWorldwide.com
5	Erin.Weidner@iriworldwide.com
6	Gail.Stuart@iriworldwide.com
7	Brian.Gregozeski@iriworldwide.com
8	Michael.Rosenthal@IRIWorldwide.com
9	Macee.Simon@IRIworldwide.com
10	Andreas.Nann@iriworldwide.com>
11
Data

Cell Formulas
Range	Formula
A4:A10	A4	=INDEX(TEXTSPLIT(A2,"<",">;"),,2)
Dynamic array formulas.

 

[Fran10]

When I try, it gives me an error:

 

[Fluff]

Looking at the image in post#5 you do not have the Textsplit function.
I'll post another option shortly.

 

[Fluff]

Ok, how about

Fluff.xlsm
	A
1
2	Shurtliff, Scott <Scott.Shurtliff@IRIWorldwide.com>; Weidner, Erin <Erin.Weidner@iriworldwide.com>; Stuart, Gail <Gail.Stuart@iriworldwide.com>; Gregozeski, Brian <Brian.Gregozeski@iriworldwide.com>; Rosenthal, Michael <Michael.Rosenthal@IRIWorldwide.com>; Simon, Macee <Macee.Simon@IRIworldwide.com>; Nann, Andreas <Andreas.Nann@iriworldwide.com>
3
4	Scott.Shurtliff@IRIWorldwide.com
5	Erin.Weidner@iriworldwide.com
6	Gail.Stuart@iriworldwide.com
7	Brian.Gregozeski@iriworldwide.com
8	Michael.Rosenthal@IRIWorldwide.com
9	Macee.Simon@IRIworldwide.com
10	Andreas.Nann@iriworldwide.com
11
Data

Cell Formulas
Range	Formula
A4:A10	A4	=LET(Txt,"<"&SUBSTITUTE(A2,">","<")&"<",s,SEQUENCE(LEN(Txt)-LEN(SUBSTITUTE(Txt,"<",""))-1),ary,REPLACE(LEFT(Txt,FIND("||",SUBSTITUTE(Txt,"<","||",s+1))-1),1,FIND("||",SUBSTITUTE(Txt,"<","||",s)),""),FILTER(ary,ISNUMBER(FIND("@",ary))))
Dynamic array formulas.

 

[Fran10]

Fluff.... you are a GENIUS!!! OMG OMG OMG.... Works perfect in the mac, in the share point and in the other computers.
THANK YOU, THANK YOU, THANK YOU

One day I want to be like you!!!! (for real)