extract text or numbers between quotes

[bzl]

I have in cell A1 Pete "33" Wilson. The following formula extracts the numbers between the quotes
=MID(LEFT(A1,FIND(""" ",A1)-1),FIND(" """,A1)+2,100). However if there is no first name and just "33" Wilson the formula will not work. How do I change the formula to extract what is between the quotes no matter where the quotes are in a cell.

[Speshul]

Try this:

Please Login or Register  to view this content.

This will also work with a variable length of string between the quotes. Bob "458762" Johnson will return 458762

Hope this helps!

[bzl]

thanks heaps Speshul...works perfectly....much appreciated

[Speshul]

No problem at all, make sure to mark the thread as [SOLVED]! (Thread Tools above your first post)