Hello,
I'm compiling data and information from many Worksheets into one table, and some of the columns contain bullet lists, which have inconsistent formatting. I've created macros to trim those fields and remove all periods, but I'm having difficulty on the next step.

I need code to find each bullet that isn't on its own row, and put it on its own row. Please help.