How do you strip html marketup from excel cells?

Question

I have a database export and I need to strip the HTML Markup from the cells in 2 columns to create a feed. Find and replace using <*> gives me "formula too long". There are about 13,000 rows. ASAP Utilities doesn't have a feature for that.

Answer 1

Use table to columns to strip out the markup using customs delimiters. The other trick is to rename it as .txt file. Open in word and do search and replace using word find & replace capabilities.