extract a foldername with a formula-update formula does not work
 

hello,

=left.,.
The formula is incomplete, i must extract different filename's
E.G.
c:\program files\eag\dir\testing\test.xls

Now the formula must extract c:\program files\eag\dir\

another example:
c:\windows\system\systemroot\test\testing.xls

The formula must extract c:\windows\system\systemroot\

So you can see, the formula must extract the file and its folder, so 2
steps

I can't get it to work, hope you can

Regards,
Niek



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

extract a foldername with a formula-update formula does not work
 

=Left(B102,len(B102)-len(cell with your formula that extracted the
filename))

--
Regards,
Tom Ogilvy

"solo_razor" wrote in message
...
hello,

=left.,.
The formula is incomplete, i must extract different filename's
E.G.
c:\program files\eag\dir\testing\test.xls

Now the formula must extract c:\program files\eag\dir\

another example:
c:\windows\system\systemroot\test\testing.xls

The formula must extract c:\windows\system\systemroot\

So you can see, the formula must extract the file and its folder, so 2
steps

I can't get it to work, hope you can

Regards,
Niek



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

extract a foldername with a formula-update formula does not work
 

I'm not sure which you wanted:

f="c:\program files\eag\dir\testing\test.xls"
mid$(f,1,WorksheetFunction.Find(chr$(22),Worksheet Function.Substitute(f,"\",chr$(22),len(f)-len(join(split(f,"\"),""))-1)))

or

f="c:\program files\eag\dir\testing\test.xls"
mid$(f,WorksheetFunction.Find(chr$(22),WorksheetFu nction.Substitute(f,"\",chr$(22),len(f)-len(join(split(f,"\"),""))-1)))


solo_razor wrote in message ...
hello,

=left.,.
The formula is incomplete, i must extract different filename's
E.G.
c:\program files\eag\dir\testing\test.xls

Now the formula must extract c:\program files\eag\dir\

another example:
c:\windows\system\systemroot\test\testing.xls

The formula must extract c:\windows\system\systemroot\

So you can see, the formula must extract the file and its folder, so 2
steps

I can't get it to work, hope you can

Regards,
Niek



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/