title: Extract text between brackets using google spreadsheets
body: <p>I want to extract the text between brackets in a cell (X3), but the usual excel formulas give a parse error in google spreadsheets.</p>
  
  <p>For example:</p>
  
  <pre><code>=MID(X3,FIND("[",X3)+1,FIND("]",X3)-FIND("[",X3)-1)
  </code></pre>
  
  <p>How to fix this parse error?</p>
  
  <p>Thanks in advance.</p>