Splitting cells into multiple columns by specific string

**KrNpRiDe** · 09-16-2009, 05:47 PM

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.

**stanleydgromjr** · 09-16-2009, 06:13 PM

KrNpRiDe,

Welcome to the Excel Forum.

Please poast your workbook (or a sample) - scroll down and see "Manage Attachments".

**KrNpRiDe** · 09-16-2009, 06:23 PM

Thank you for your reply. I have attached the excel file as an example.

Thank you in advance.

**DonkeyOte** · 09-17-2009, 03:38 AM

I would suggest posting the expected results also -- ie in your OP you mention splitting A1 into A2,A3 etc whereas in your sample file A2 is another row of data... so I presume you in fact mean to split A1 into B1 onwards based on LI tag ?

Please Login or Register  to view this content.

given the requirement for adding LI to the various strings which can exceed 255 chars in length iteration is required (rather than a simple write back of the array and subsequent evaluate to append strings)