I have an excel spreadsheet that contains a description column that has cells that contain numbers within ""
eg
<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
eg
Signal Mast @ 243.968 - R/R/ML/SG - 2002 Galv Tube - "244/12"</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>
the cells are not consistant in length & some cells do not contain any ""
Thanks in anticipation ...
Anne