Return elements between commas

[Tarheel8181]

Hi -- Please see attached. I need a formula that can separate out elements between commas. Any ideas?

 

[NARAYANK991]

Hi ,

See if this works. You will have to change the references to suit.

Narayan

 

[bosco_yip]

Here is a copy down formula solution.

In C2, formula copy down :

=IF(A2="",TRIM(MID(SUBSTITUTE(", "&MID(LOOKUP("zzz",A$1:A2),FIND(":",LOOKUP("zzz",A$1:A2))+2,99),", ",REPT(" ",99)),COUNTIF(INDEX(A$1:A2,MATCH("zzz",A$1:A2)):A2,"")*99,99)),"")

Regards
Bosco