=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/