Thread: Getting a string of data from a file name
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dav Dav is offline
external usenet poster
  
Posts: 1
Default Getting a string of data from a file name

If filepath is in cell A1 try

=MID(A1,FIND("[",A1)+1,FIND("gym",A1)-FIND("[",A1)-2)

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=564582

Reply With QuoteReply With Quote