Adding comma to string

[jharaldson]

Hey all,
I need a little help adding commas to this string. When I run this code below I get the result, A-(BCD)-(BCDEF). What i want is A-(B,C,D)-(B,C,D,E,F). I tried adding a join to it but keep getting a type mismatch error. Any help would be appreciated.

thanks
jeremy

Please Login or Register  to view this content.

[nathansav]

Please Login or Register  to view this content.

Something like this, im not in excel at the mo so havent tested.

[jindon]

This should do

Please Login or Register  to view this content.

[jharaldson]

thanks jindon