<div>
Hi,<br />
<br />
I did mean backslash!!<br />
<br />
Works a treat, many thanks.<br />
<br />
James
</div>


Hi,

I did mean backslash!!

Works a treat, many thanks.

James

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Pretty simple one I think...If I have say:<br />
<br />
C:/folder1/folder2/folder3<wbr />/folder4/f<wbr />older5/fil<wbr />e.xls....<br />
..in a cell could I write a formula in the cell next to it that would extract the folder that the file is in, so for the above example the formula would return *folder5* as the file.xls is in folde5.<br />
<br />
So basically the formula would be returing what is in the inbetween the last forward slashes /***/, 'folder5'..<br />
<br />
Thanks
</div>
</div>


Hi,

Pretty simple one I think...If I have say:

C:/folder1/folder2/folder3/folder4/folder5/file.xls....
..in a cell could I write a formula in the cell next to it that would extract the folder that the file is in, so for the above example the formula would return *folder5* as the file.xls is in folde5.

So basically the formula would be returing what is in the inbetween the last forward slashes /***/, 'folder5'..

Thanks

Extract folder from path - Excel Formula

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.