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

Advertisements

Comments

  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!

Trackbacks

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

%d bloggers like this: