Extract text from between the second set of inverted commas (double quotes)

[Emile du Toit]

I could REALLY do with some help, as I cannot find an online answer to this question. I am extracting text from a large chunk of text in a cell, and most of it is pretty simple. However, the one bit of text I need to extract occurs in a section of the cell where symbols and suchlike vary too much depending on the cell, so it is difficult to find two constant symbols to use to extract the text.

The only pattern I can find is that the text I need to extract always appears within the second set of inverted commas (double quotes), though the total number of double quotes can vary.

So three cells might look like this:
A2: can & XCT , and , "what is it?", pirate, "cat", Fstop
A3: doll& instance , "8 or so", 98 "tortoise", xtr IT "six or seven"
A4: sip, "99 or so" can it be, ??, pot +, fixer, "sheep or goats" "Index", "a pox on all these formulas" & fittest

Working in column B I am trying to extract:
B2: cat
B3: tortoise
B4: sheep or goats

 

[63falcondude]

Try

=TRIM(MID(SUBSTITUTE(A2,"""",REPT(" ",999)),2999,999))

This formula pulls out the text between the 3rd and 4th quotation marks.

 

[Emile du Toit]

Thank you that worked brilliantly!

 

[63falcondude]

Thank you that worked brilliantly!

Great! You're welcome.