Hi there,

I have a workbook with some text I really need to tidy up, so it'll be accepted by a program I use.

Some sort of SPLIT function could do it - but there's an added twist.

Before I launch into a confusing description, here's an illustration of the desired effect:

BEFORE
Title: Love Can Build a Bridge
Performer: Cher/Chrissie Hynde/Neneh Cherry

AFTER
Title: Love Can Build a Bridge
Performer: Cher
Performer: Chrissie Hynde
Performer: Neneh Cherry

So - I’d like a macro that looks through the active workbook area (it’ll only be Column A.)
If it finds a string that starts “Performer: ” AND contains the character “/”, it should split this string using the “/” as a delimiter.
It should create a new row below, where it should place the portion of the string that was after the delimiter. (Ideally, it would trim off any leading space too.)

Importantly, every cell containing a fragment of the original string needs also to start with: “Performer:”.

Multiple “/”s in the string would mean multiple new rows beneath, to hold the resulting substrings.

There's a workbook attached with a lengthier example.
performer-splitter.xlsx

Thank you for any help you can give,
Matt