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
Bookmarks