Strip out all HTML Tags from an excel file

I have an excel file that has cells with text that includes HTML tags.

The data was exported from a database and the HTML tags were included.

The HTML is stored as text, but I need it gone.

Is there a quick easy way to remove it all (other than find/replace)?


Solution 1:

Try using Excel's search/replace with wildcards. You can use * to match any string (including empty string) or ? to match a single character.

So using:

Find what: <*>

Replace with: leave blank

will remove HTML tags from your cell contents.