split the events and paste it with same information

[faddies]

hi guys

please see the file attached


I want to split the events on the baises of "," "&" " - " or some thing else if reuired
I want to split these events copying exactily the same cells with it
I hope you can understand what I want to do ?? see the attached file


its very importent to solve because it will save my tons of time ... please

[faddies]

Hello ?? any body there ?

[amotto11]

I could get you a formula for the first word, then you would have to have a different one for the second, third, fourth and such going down the list. It would sort of be pointless because it would take longer to use the formulas than to just write in the words.

[jindon]

try

Please Login or Register  to view this content.

[faddies]

its not working on my sheet ?? can you please attach the sheet.

[jindon]

Here

splitWithCode.xlsm

[faddies]

WOW buddy you are pretty close ... your code is working very well but if my event is like "Kiss 104.1 Flashback Festival: Jeffrey Osborne, Faith Evans & Morris Day"

it split it to
{
Kiss
Flashback Festival
Jeffrey Osborne
Faith Evans
Morris Day
}


but in actual i want the result as

{Kiss 104.1 Flashback Festival
Jeffrey Osborne
Faith Evans
Morris Day}

Your formula is also splitting the event on the bases of numbers too .. please use the keyword to split in your sheet to see the results "Kiss 104.1 Flashback Festival: Jeffrey Osborne, Faith Evans & Morris Day"


I really appreciate your efforts .. thank you so much in advance

[jindon]

Change pattern to

Please Login or Register  to view this content.

[faddies]

Thanks man its working very well ... thank you so much ...