title: How to convert HTML formatting inside google sheets rows to their correct formatted equivalent
body: <p>I have been looking for a solution to convert a database I have with HTML formatting in one of the columns to its "normal" text equivalency in google sheets. A lot of the solutions I've found dealt with writing programs to do this or using Excel, so they unfortunately didn't pertain well enough.</p>
  
  <p>For example in one of my columns I have;</p>
  
  <p><code>Fast (&lt;i&gt; This character deals damage before non-&lt;b&gt;Fast&lt;/b&gt; characters in combat.&lt;/i&gt;)</code></p>
  
  <p>But I would like to be able to have a somewhat streamlined solution to convert the above to:</p>
  
  <p>Fast (<i>This character deals damage before non-<b>Fast</b> characters in combat.</i>)</p>