Convert HTML to Excel cell formating

[markashman]

Hi, I have an API download that includes text fields that contain standard html, so <p> for new lines & <li> for bullet lists.

I want to maintain this when loading into excel, so need to convert it to something excel understands so my output in an excel looks something like:

We need these items:

• A Box
• A Table
• A Chair

Thanks

Anyone have a method for doing this?

[CoG · Accepted solution]

Without sample input, its difficult to provide exact info. I didn't use precise HTML formatting, but this workflow should point you in the right direction:

Happy Solving!

[markashman]

Thanks, useful - there are so may variants of tags in the same return, so <li> & <li style.. etc I ended up having to use multiple nested REGEX_replace in multiple formula tools, but got there in the end.