title: How to remove all short code (almost similar) from a column on Google sheet
body: <p>I have a Google sheet array with a column of 63 rows (column <code>C</code>) with short codes,</p>
  <pre><code>[audio mp3:=&quot;https/....&quot; ][/audio]
  </code></pre>
  <p>Each line has this tag but with a different link.
  but always with this<br />
  <code>[audio mp3:=&quot;https/....&quot; ][/audio]</code></p>
  <pre><code>C1: [mp3 audio:=&quot;https/upload/content/file1.mp3&quot;][/audio]  
  C2: [mp3 audio:=&quot;https/upload/content/file2.mp3&quot;][/audio]  
  </code></pre>
  <p>How do I find and delete all terms that start with &quot; [mp3 audio&quot; and end with &quot;[/audio]&quot; on all 63 rows in column C`?</p>