Thread: Extracting Workbook name
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] brian@intabanet.co.za is offline
external usenet poster
  
Posts: 9
Default Extracting Workbook name

Ron Rosenfeld wrote:
On 1 Oct 2006 10:31:11 -0700, wrote:

I have a workbook which has a list of path and filenames for workbooks.
I want to extract from each of these the workbook name only.
e.g From this path I want to extract only the name "Lucky Draw.xls"

C:\Documents and Settings\Bbrian\My Documents\My Documents\Brian
docs\Clay\Clay WorkBooks\Workbooks\Lucky Draw.xls

Each of the path names are vaiable lengths and a variable number of sub
direcotries

This will return the string that begins after the final "\" :

=MID(A1,FIND(CHAR(1),SUBSTITUTE(A1,"\",CHAR(1),
LEN(A1)-LEN(SUBSTITUTE(A1,"\",""))))+1,255)


--ron

Reply With QuoteReply With Quote