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)?

4

1 Answer

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.

3

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy