title: html to text in excel cell
body: <p>I am looking to convert HTML in excel cells to plain text. For example, I have this in cell C18:</p>
  
  <pre><code>&lt;p&gt;&lt;b&gt;ORGANIC LIP BALM &lt;/b&gt;&lt;/p&gt;&lt;p&gt;&lt;b&gt;Peppermint&lt;/b&gt;&lt;/p&gt;
  </code></pre>
  
  <p>The output in D18 should be:
  ORGANIC LIP BALM Peppermint</p>
  
  <p>Looking for a VBA macro to do the conversion. The HTML itself is located within the cells of a column. So for example, rows 1-100 in column C have HTML in them, which I want to convert to plain text in column D.</p>
  
  <p>Can anyone help?</p>