Remove HTML from Excel Files

Occasionally I will have an Excel file that contains HTML markup that I need to remove. The Excel Replace feature makes removing HTML easy. To remove the HTML tags highlight the cells that contain the HTML and then select Edit > Replace. In the “Find what” field enter <*>. Leave the “Replace with” field blank and then click on the “Replace All” button. Poof! All of your HTML will magically be removed.

html_replace

Advertisement