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.
Remove HTML from Excel Files
June 18, 2013 by