Need macro or formula to remove HTML codes

[bkaehny]

Hi all,

I have a column of data that contains product descriptions. Some of these descriptions contain HTML code (e.g. < b >, < li >, etc.). I would like an easy way to remove all these codes. Some formula or macro that removes anything between < and > would work great. Does such a solution exist? Thanks in advance for your help.

 

[andiemac]

Try this - assuming your data is in column A.

Sub Remove_All()
Dim LR As Long
Range("A1").End(xlDown).Select
LR = ActiveCell.Row
With Range("A1:A" & LR).Select
    Selection.Replace What:="<*>", Replacement:="", LookAt:=xlPart, _
        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
        ReplaceFormat:=False
End With
End Sub

 

[bkaehny]

That worked great. Thanks!