flie path at a lower directory

[cmendes]

Dear all,

I want a formula that gives me the path of the file but without a last folder. I know the formula for the complete path: =LEFT(CELL("filename"),FIND("[",CELL("filename"),1)-1)

For example, the complete file path is:
C:\Documents and Settings\Cesar\MyDocuments\fTIR\wt_RAL-315\1_28_11Ral_WT_1\Results\

I'm looking for a formula that gives me:

C:\Documents and Settings\Cesar\MyDocuments\fTIR\wt_RAL-315\1_28_11Ral_WT_1\

i.e. without 'Results\'

Many thanks!!
Cesar
<table style="width: 471px; height: 38px;" border="0" cellpadding="0" cellspacing="0"><col width="325"><tr height="17"> <td class="xl65" style="height: 12.75pt; width: 244pt;" width="325" height="17">
</td> </tr></table>

 

[T. Valko]

By the way, does this hold true to all the excel files that I use in the future? I tried in another saved file and it did not work, I had to go to Defined Names>Define Name.
Thanks
C

Yes, you'd have to do the same thing in each file.