Hi, all.
I am trying to split/break a lengthy string into multiple cells by columns.
The specific string in my case is <li> or <LI>.

The cell contains html code that I want to break up into separate cells and still include the <li> or <LI> at the beginning of the string.

For example, the cell A1 contains "blah blah blah <li> ha ha ha ha </li><LI> he he he </LI><Li> ho ho ho</Li>"

I want this divided up into following format.
A2: "blah blah blah"
A3: "<li> ha ha ha</li>"
A4: "<LI> he he he </LI>"
A5: "<Li> ho ho ho </Li>"

Also, there is no limit to how many <LI> would be in the cell, so it has to continue searching the whole text in the string.

Any help would be greatly appreciated.

Thank you for the help in advance.