Remove HTML Tags

[COGICPENNY]

I want to remove HTML code from the text string in my file. Is there a simple way to quickly convert the text in column E "Body HTML" to just plain text? I'm doing this because when the inventory file is uploaded to my website, some of the rows come off showing the html symbols instead of text and some don't. The easiest fix and future management is to just remove the code.

Link to the file: https://drive.google.com/file/d/1wZw9Xv ... sp=sharing

[HansV]

Select the Body HTML column.
Press Ctrl+H to activate the Replace dialog.
Enter <*> in the 'Find what' box.
Leave the 'Replace with' box empty.
Click 'Replace All'.

[COGICPENNY]

Find and replace will not help me in this situation because there are multiple html code text.

[PrestonK]

Try this:

Sub RemoveHyperlinks()

'Remove all hyperlinks from the active sheet
ActiveSheet.Hyperlinks.Delete

End Sub


Preston

[HansV]

Find and replace will not help me in this situation because there are multiple html code text.

Have you actually tried it? If so, can you provide a concrete example of where it failed?