Extract data between html tags and place in new cells

Hi, I have a cell in Excel that contains data that has text that I need to extract placed between <li> </li> tags. Example:

<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum</p>
<ul>
<li>need this bullet point extracted and put into a new column</li>
<li>need this bullet point extracted and put into a new column</li>
<li>need this bullet point extracted and put into a new column</li>
<li>need this bullet point extracted and put into a new column</li>
<li>need this bullet point extracted and put into a new column</li>
</li>
</ul>

I would like the text between the <li> and </li> tags to be put into new columns in the same row while leaving the description in the original cell. I have about 10,000 lines to do and am hoping that there is a way to avoid doing these one at a time. Any help is truly appreciated!

The VBA macro seems to be the best solution however I was not able to get it to work, when I pasted it into a new module and ran it nothing happened.

The 2 formulas did move the items to the next cell but did not strip the HTML or separate each bullet into a new cell.

My apologies, a bullet is defined as any text between the <li> and </li> tag in the original post.

Assuming the data in col.A

Please Login or Register  to view this content.

This caused a "Runtime Error 429, activeX component can't create object". When I selected "Debug", the line highlighted was With CreateObject("VBScript.RegExp")

You don't normally need to do this,but try set the reference to

Microsoft VBScript Regular Expressions x.x

While you are in VBE, go to [Tools] - [Reference] then tick the box.

FDibbins - That is correct, the ones you bolded.

Jindon - I will try your file tomorrow morning when I get into work and follow up with you. Thank you.

That doesn't solve the issue though, what that is doing is moving all of the data between the <li> and </li> tags into a new cell together, what I need is each data set between <li> and </li> to be extracted and moved into its own cell. Please accept my apologies if I didn't make that clear in my original post.

Sample Workbook.xlsx

This is what I would like the outcome to be.

My file is doing exactly how you want ...

Jindon, I will check on my office computer in the morning, I am on office 2011 on a mac at home and I suspect that's the issue. I am on 2013 at work.

Or this should do the same

Please Login or Register  to view this content.

That did it! Thank you so much!!!