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
Remove HTML Tags
-
- Administrator
- Posts: 78534
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Remove HTML Tags
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'.
Press Ctrl+H to activate the Replace dialog.
Enter <*> in the 'Find what' box.
Leave the 'Replace with' box empty.
Click 'Replace All'.
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 115
- Joined: 20 Mar 2018, 13:40
Re: Remove HTML Tags
Find and replace will not help me in this situation because there are multiple html code text.
-
- Lounger
- Posts: 46
- Joined: 10 Feb 2010, 14:27
Re: Remove HTML Tags
Try this:
Sub RemoveHyperlinks()
'Remove all hyperlinks from the active sheet
ActiveSheet.Hyperlinks.Delete
End Sub
Preston
Sub RemoveHyperlinks()
'Remove all hyperlinks from the active sheet
ActiveSheet.Hyperlinks.Delete
End Sub
Preston
-
- Administrator
- Posts: 78534
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Remove HTML Tags
Have you actually tried it? If so, can you provide a concrete example of where it failed?COGICPENNY wrote: ↑24 Nov 2020, 00:18Find and replace will not help me in this situation because there are multiple html code text.
Best wishes,
Hans
Hans