title: Remove text appearing between two characters - multiple instances - Excel
body: <p>In Microsoft Excel file, I have a text in rows that appears like this:</p>
  
  <pre><code>1. Rc8 {[%emt 0:00:05]} Rxc8 {[%emt 0:00:01]} 2. Rxc8 {[%emt 0:00:01]} Qxc8 {} 3. Qe7#  1-0
  </code></pre>
  
  <p>I need to remove any text appearing within the flower brackets <code>{</code> and <code>}</code>, including the brackets themselves. </p>
  
  <p>In the above example, there are three instances of such flower brackets. But some rows might have more than that. </p>
  
  <p>I tried <code>=MID(LEFT(A2,FIND("}",A2)-1),FIND("{",A2)+1,LEN(A2))</code> </p>
  
  <p>This outputs to: <code>{[%emt 0:00:05]}</code>. As you see this is the very first instance of text between those flower brackets.</p>
  
  <p>And if we use this to within SUBSTITUTE like this: <code>=SUBSTITUTE(A2,MID(LEFT(A2,FIND("}",A2)),FIND("{",A2),LEN(A2)),"")</code></p>
  
  <p>I get an output like this:</p>
  
  <p><code>1. Rc8  Rxc8 {[%emt 0:00:01]} 2. Rxc8 {[%emt 0:00:01]} Qxc8 {} 3. Qe7#  1-0</code> </p>
  
  <p>If you have noticed, only one instance is removed. How do I make it work for all instances? thanks.</p>