extract text between quotations

[excel_2009]

Hi excel gurus,

Would it be possible to extract the values between quotations?

[TABLE="width: 537"]
<tbody>[TR]
  [TD="width: 537"]identifier="key"  key="Maximal-Leistung" name="Maximal-Leistung" [/TD]
[/TR]
</tbody>[/TABLE]

so that the output shows the Key value i.e. Maximal-Leistung

Please can someone help

 

[steve the fish]

Try:

=TRIM(LEFT(SUBSTITUTE(MID(A1,FIND("key=",A1)+5,99),"""",REPT(" ",99)),99))