return value contained in cell within ""

[AJohn01]

I have an excel spreadsheet that contains a description column that has cells that contain numbers within ""
eg

Signal Mast @ 243.968 - R/R/ML/SG - 2002 Galv Tube - "244/12"</SPAN>

<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>

I need to get a formula that extracts the numbers within the "" or if none return value of NIL

the cells are not consistant in length & some cells do not contain any ""
Thanks in anticipation ...
Anne

 

[Haseeb Avarakkan]

Also a shorter?

=TRIM(LEFT(SUBSTITUTE(REPLACE(A1,1,FIND("""",A1&""""),""),"""",REPT(" ",99)),99))

 

[T. Valko]

I have an excel spreadsheet that contains a description column that has cells that contain numbers within ""
eg

Signal Mast @ 243.968 - R/R/ML/SG - 2002 Galv Tube - "244/12"</SPAN>

<TBODY>
</TBODY>

I need to get a formula that extracts the numbers within the "" or if none return value of NIL

the cells are not consistant in length & some cells do not contain any ""
Thanks in anticipation ...
Anne

Here's another one...

=TRIM(MID(SUBSTITUTE(A2,"""",REPT(" ",100)),100,100))

Assumes that if there is one quote " then there will be a matching quote ".

 

[AJohn01]

Excellent thanks very much for the shorter formula....

 

[T. Valko]

Excellent thanks very much for the shorter formula....

You're welcome!