Excel – Strip out all HTML Tags from an excel file

microsoft excelmicrosoft-excel-2007

I have an excel file that has cells with text that includes HTML tags.

The data was exported from a database and the HTML tags were included.

The HTML is stored as text, but I need it gone.

Is there a quick easy way to remove it all (other than find/replace)?

Best Answer

Try using Excel's search/replace with wildcards. You can use * to match any string (including empty string) or ? to match a single character.

So using:

Find what: <*>

Replace with: leave blank

will remove HTML tags from your cell contents.

Related Solutions

Excel – How to easily remove hyperlinks from multiple cells

An option would be to let a VBA Macro do the donkey work.

Press Alt-F11, double-click This Workbook, then copy this code into the resulting window (essentially only one line of code!):

Sub RemoveHyper()
    Selection.Hyperlinks.Delete
End Sub

Press Alt-F11 to go back to your spreadsheet, select all the cells with hyperlinks, then do Alt, T, M, M (or Alt-F8) and select the RemoveHyper Macro, then select Run.

When you're done, if you want to remove the Macro, either save the file as .xlsx, or press Alt-F11 and remove the code.

Excel insists on formatting HTML

What eventually worked was rewriting the SQL query to add a pipe ( | ) between all fields (since the pipe didn't appear in any of the text), then saving the results to a text file and importing that as pipe-delimited data, formatting every column as text in the import dialog.

Best Answer

Related Solutions

Excel – How to easily remove hyperlinks from multiple cells

Excel insists on formatting HTML

Related Question