Navigate to the cell with the HTML tags you want to delete. Add a "Html to text" action, Content field set to Description dynamic content of the trigger. Yes No Seltsameliebe Replied on May 14, 2014 In the Advanced Editor, paste the following: (HTML as text) => let Source = Text.From (HTML), SplitAny = Text.SplitAny (Source,"<>"), ListAlternate = List.Alternate (SplitAny,1,1,1), ListSelect = List.Select (ListAlternate, each _<>" "), TextCombine = Text.Combine (ListSelect, " ") in TextCombine 3. Click on the Upload button and select File. 2. Strip or remove all simple html tags with formula. Name it "HTML Cleaner". If you don't like the result, for example because too much has been removed, press Ctrl+Z to undo the replacement. . Pasted your sample HTML data in PQ using ENTER DATA table option, you can import from your HTML file as Web source. So the data looks like this. Open the tool vba-to-remove-html-tags.xlsm and the Excel file containing the HTML tags. The content gets copied with html tags. Press Ctrl+H. Advertisement. TIA Rick. 1. In this article Syntax Html.Table(html as any, columnNameSelectorPairs as list, optional options as nullable record) as table About. Hold down the Alt + F11 keys in Excel, and it opens the Microsoft Visual Basic for This tool will strip all HTML tags in the selected cells, such as for example
,
,
, ,