split the events and paste it with same information

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

Hello ?? any body there ?

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

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

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