title: HTML Text with tags to formatted text in an Excel cell
body: <p>Is there a way to take HTML and import it to excel so that it is formatted as rich text (preferably by using VBA)? Basically, when I paste to an Excel cell, I'm looking to turn this:</p>
  
  <pre><code>&lt;html&gt;&lt;p&gt;This is a test. Will this text be &lt;b&gt;bold&lt;/b&gt; or &lt;i&gt;italic&lt;/i&gt;&lt;/p&gt;&lt;/html&gt;
  </code></pre>
  
  <p>into this:</p>
  
  <p>This is a test. Will this text be <b>bold</b> or <i>italic</i></p>