Hello,

If you could use in-cell formulas for this...

This assumes that your list of names starts in cell "A1":

In cell "B1" enter:
=IF($A1<"",LEFT(A1,FIND(",",A1)-1),"")

In cell "C1" enter:
=IF($A1<"",MID(A1,(FIND(",",A1)+2),(FIND("
",A1,LEN(B1)+3))-(FIND(",",A1)+2)),"")

In cell "D1" enter:
=IF($A1<"",MID(A1,(LEN(B1)+LEN(C1))+4,LEN(A1)-(LEN(B1)+LEN(C1)+3)),"")

then fill down.

Regards,
GS