Wow... I never even thought of that... Tom, you are a better man than I. Just
a note for Gord though. That formula uses Indirect which is volatile and so
everywhere that it is used (4,000 cells in this case) will re-calc with every
calculation. Gordon, once you have extracted the numbers you may want to copy
and paste special values over those formulas (all but one so that you still
have the fromula handy for the next time you want it) otherwise you may find
that your spreadsheet will be running very slowly.

Once again Tom, I tip my hat to you...
--
HTH...

Jim Thomlinson


"Tom Ogilvy" wrote:

Here is one way

=MID(A2,SMALL(IF(ISNUMBER(MID(A2,ROW(INDIRECT("1:" &LEN(A2))),1)*1),ROW(INDIRECT("1:"&LEN(A2)))),1),F IND(".",A2)-SMALL(IF(ISNUMBER(MID(A2,ROW(INDIRECT("1:"&LEN(A2) )),1)*1),ROW(INDIRECT("1:"&LEN(A2)))),1))

Entered with Ctrl+shift+enter rather than just enter since this is an array
formula.

As written extracts the number from a string in A2.

--
Regards,
Tom Ogilvy


"Gordon" wrote:

Hi

This didn't work. The text string varies in length pretty much every time as
does the number string and the length of the number. Thanks anyway.

Gordon.

"Barb Reinhardt" wrote:

You could strip out the file name fairly quickly with
=Right(A1,len(A1)-28)

(I hope I counted correctly)

"Gordon" wrote:

Hi...

I have 4000 entries in column A similar to...

C:\Common Standards Reports\Spare Parts 0606.xls
C:\Common Standards Reports\Steering wheels 110606.xls
C:\Common Standards Reports\yellow paint 22876.xls

I need the corresponding/adjacent cell in column B to strip out the number
string so that said cells read:

0606
110606
22876

Can this be done?

Thanks in advance...