View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gordon[_2_] Gordon[_2_] is offline
external usenet poster
 
Posts: 211
Default Challenging Formula

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