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.




  1. Thanks, it worked for me and modified 19286 records in a second.

  2. You have no idea how useful that was for a silly newbie, who would do it by hand instead. Thank you very, very much. Great tip!


  1. […] Otherwise you can simply use find/replace in Excel as described here. […]

%d bloggers like this: