How to clean HTML from text in a cell.
Posted by Garrett on November 16, 2000 1:30 PM
I've got about 10,000 product names/rows that have corresponding "descriptions" in a separate column. Problem: the descriptions for these products have HTML randomly embedded w/in the text (bold, italics, bullets, etc). I need to clean all of the tags from the content so that the "clean" content can be loaded into a database.
I can do it by using "search, subst, and replace" but it's extremely cumbersome. My VBA skills are quite weak/nonexistent at this point.