HTML Decode a String in Excel, No Plugins Required
This function converts an HTML encoded string to its regular text representation without having to install third party plugins. Public Function HtmlDecode(StringToDecode As Variant) As String Set oMSHTML = CreateObject(“htmlfile”) Set e = oMSHTML.createElement(“T”) e.innerHTML = StringToDecode HtmlDecode = e.innerText End Function To add it to Excel: 1. Type ALT+F11 2. In the File menu […]