title: Microsoft Excel: How to extract "text with quotes "from quotation marks"
body: <p>I need to extract text containing quotes from quotation marks. Example, TRADE HOUSE "LLC"MEXICAN APPLES" THROUGH TESCO. I need to have in an adjacent cell "LLC"MEXICAN APPLES".</p>
  
  <p>I tried </p>
  
  <pre><code>=MID(A1, SEARCH("""",A1, SEARCH("""",A1)-SEARCH("""", A1))
  </code></pre>
  
  <p>It did not work. I cannot understand how to set the length of the text to be extracted. The length of the text varies.</p>