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...