Convert HTML tags to Excel text format

Hey there fellas,

I got an excel file with 316 rows with HTML tags, I'd like to format them into excel text i.e. "Members of this group can:<UL><LI>View, create and edit time sheets.</LI><LI>Add approval requests to the approval flow for time sheets.</LI></UL>".

I found a couple of macros on line and the one I think could solve is trowing me this error "ActiveX component cant create object"

All text is in column C and I'd like to paste the result in another column.

Please Login or Register  to view this content.

Thanks in advance for the help! Edit: added text sample

As Excel can directly read a HTML file, first try to open it with Excel or via a Drag & Drop …

Originally Posted by CristianCGP

... HTML tags ... "... <UL><LI>...</LI><LI>...</LI></UL>" ...

If there are only tags for an unordered list then you can do it this way:
(Text with tags in 'A1')

Please Login or Register  to view this content.