So, I have some cells that contain data like this:
ABCDE: @ CT 8:59 1)Text Data One 2)Text Data Two 3)Text Data Three.

I want to split up the cell so that the each set of data is in its own column.

I thought I could just use Text to Columns on the ")" sign but some of the data could actually contain parenthesis.

So I need a way that it can actually look for "1)" or "2)" or "3)" and do the split at that set of characters.

Can anyone assist me with this?

Thanks!