Excel: Remove HTML Tags and Escape Codes from an Excel selection

The code below 1 can be used to remove HTML tags and escape codes from an Excel selection.  Simply page the code into a new module, select the relevant cells to be processed, and press run.

I would suggest that you copy the original cells to another sheet and then try it on the copy first, just to make sure it works the way you want.

I have found a list of the Escape Codes, at http://www.bryanlprice.com/specials.html, but there are others.  I haven’t included all of them in the code below, as they were not relevant for my purposes.

I have also found a list of HTML character codes, at http://www.btinternet.com/~andrew.murphy/html_character_set.html.

  1. Please ensure you test any script taken from my website on a test/development machine, before running on a production server.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

CJayMead's SQL Server, Endeca, MS Office Help © 2018