Microsoft Excel: How to extract "text with quotes "from quotation marks"
<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>