<div>
You can use the following function<br />
<br />

<pre><code id="code-20-38038800-1">Function HtmlToText(sHTML) As String
  Dim oDoc As HTMLDocument
  Set oDoc = New HTMLDocument
  oDoc.body.innerHTML = sHTML
  HtmlToText = oDoc.body.innerText
End Function</code></pre>
</div>


You can use the following function



Function HtmlToText(sHTML) As String
  Dim oDoc As HTMLDocument
  Set oDoc = New HTMLDocument
  oDoc.body.innerHTML = sHTML
  HtmlToText = oDoc.body.innerText
End Function

<div>
Can you please provide some simple steps on how to use this function in Excel 2010? I have an entire column that has the HTML; I want to replace the HTML in every single cell in that column with plain text.<br />
BTW, with this function, what happens to the bulleted lists?
</div>


Can you please provide some simple steps on how to use this function in Excel 2010? I have an entire column that has the HTML; I want to replace the HTML in every single cell in that column with plain text.
BTW, with this function, what happens to the bulleted lists?

HTMLTextExtract.xlsm

<div>
Thanks for the excellent response!
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have an Excel file that has a field called &quot;Description&quot;. &nbsp;This field has got HTML in it, and it prints 2-3 HTML formatted lines. &nbsp;The format includes bulleted lists and bolded/italicized text.<br />
<br />
Does someone have a way of converting this ENTIRE column into plain text, i.e. stripping of the HTML completely?
</div>
</div>


Hi,

I have an Excel file that has a field called "Description".  This field has got HTML in it, and it prints 2-3 HTML formatted lines.  The format includes bulleted lists and bolded/italicized text.

Does someone have a way of converting this ENTIRE column into plain text, i.e. stripping of the HTML completely?

Stripping HTML from an Excel column and replacing it with plain text

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.