IF statement help

[JonnyEnglish89]

So I wanted extract any text between quotation marks in cell A1 in sheet1 and achieved that by using this formula:

=MID(Sheet1!A1,(FIND("""",Sheet1!A1,1)+1),(FIND("""",Sheet1!A1,(FIND("""",Sheet1!A1,1)+1)))-(FIND("""",Sheet1!A1,1)+1))

Is there a way to return a string of text if nothing was found between the quotation marks?

 

[steve the fish]

How about:

=IF(LEN(TRIM(SUBSTITUTE(A1,"""",REPT(" ",LEN(A1)))))=0,"Nothing",TRIM(MID(SUBSTITUTE(A1,"""",REPT(" ",LEN(A1))),LEN(A1),LEN(A1))))

 

[steve the fish]

Sorry this:

=IF(LEN(TRIM(MID(SUBSTITUTE(A1,"""",REPT(" ",LEN(A1))),LEN(A1),LEN(A1))))=0,"Nothing",TRIM(MID(SUBSTITUTE(A1,"""",REPT(" ",LEN(A1))),LEN(A1),LEN(A1))))

 

[JonnyEnglish89]

Great, that works like a charm!
Thank you!