Whether I can help or not I'm not sure.
I took the examples you gave, (which I assume are representative of the data in your concatenated column), and varied and duplicated them a few times (only 60 odd rows) and the formula you included certainly works for the information presented as a general...
Welcome Amy,
I hope you find the support you need.
It looks as though you may now be beyond my level of expertise but I expect others can assist.
Cheers,
Paul
67, Australia
Hi all.
More greetings from Australia. I'm Paul in Hobart.
Looking forward to interacting here, no doubt learning lots but hopefully occasionally contributing too. I've been dabbling in spreadsheets and databases since before Excel was born but never had enough opportunity to keep up with...