Name it "HTML Cleaner". *?\>" .Global = True For Each r In Selection r.Value = .Replace (r.Value, "") Next r End With End Sub Open up the VBE with Alt+F11 and locate your workbook in the top left Project Explorer window. Select the cells that you want to remove the HTML tags. This tool will strip all HTML tags in the selected cells, such as for example
,
, ,