Hi, i would like to extract data between commas and display them in a cell. And if they have a number inside a bracket to break them up multiple times (dependent on their number)
For example in Cell A1 = Kevin Day, Peter Jones (2), Nathan Quinn, Luke Daly (3)
Cell A2 = Kevin Day
Cell A3 = Peter Jones
Cell A4 = Peter Jones
Cell A5 = Nathan Quinn
Cell A6 = Luke Day
Cell A7 = Luke Daly
Cell A8 - Luke Daly
Any help is much appreciated.
Regards,
Bookmarks