Excel Macro for inserting HTML Tags

[halo12]

Hi.. I need excel macro for inserting following html tags in cell. The structure will be the same. The header "Details:" and "Contents:" will not be always available. Have inserted the excel.


Before:
This is a test sentence

Details:
Test1
Test2

Contents:
Test1
Test2

After
<p>This is a test sentence.</p><p><b>Details:</b></p><ul><li>Test1</li><li>Test2</li></ul><p><b>Contents:</b></p><ul><li>Test1</li><li>Test2</li></ul>

[halo12]

Can someone please help