macro to split up HTML codes

[MrCardinal]

Hi all,

I am trying to extra data from HTML code into different columns. I have 5 bullet points and 3 paragraphs that I would like extracted into 8 columns, all in the same row. Here is the HTML code:

<ul><li>Bullet Point 1</li><li>Bullet Point 2</li><li>Bullet Point 3</li><li>Bullet Point 4</li><li>Bullet Point 5</li></ul><p>Paragraph 1</p><p>Paragraph 2</p><p>Paragraph 3</p>

The data will always be in one cell and I am looking to export it across the same row but 8 different columns (the 5 bullet points and 3 paragraphs).

Does anyone know how to write a macro to do this?

Thanks

[jindon]

Try this

Please Login or Register  to view this content.

[MrCardinal]

I must need to take a basic course on macro's- how do I get this to run?

[jindon]

Can you upload a small sample workbook?

So that I can install the code and adjust if needed.

[MrCardinal]

I'm not sure how to upload to here. If you put this in cell A1, that will be the workbook:


<ul><li>Bullet Point 1</li><li>Bullet Point 2</li><li>Bullet Point 3</li><li>Bullet Point 4</li><li>Bullet Point 5</li></ul><p>Paragraph 1</p><p>Paragraph 2</p><p>Paragraph 3</p>

I have only run one other macro and the way I did that was click on Macros>Record Macro, put in a name, went to view macro and edit and then put in the macro code- is that what I need to do? I tried it and can't get it to work.

[jindon]

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[MrCardinal]

Hey! I got the macro to work! Thanks so much!

[jindon]

Good.

If it solved your problem, please mark this thread as "Solved".