Modifying the pathway in Excel

[catsmeowiam]

I would like to show a modified pathway on my footer in Excel. I want it to read Folder, File, Tab. Is this possible?

Thanks in advance!

 

[Andrew Poulsom]

Welcome to the Board.

There are icons for that on the Footer dialog (File|Page SetUp|Header/Footer tab|Custom Footer). It would be:

&[Path]&[File]&[Tab]

 

[catsmeowiam]

I want to modify that pathway. I do a lot of litigation work and want to limit the amount of information that is visible. I just want to see the name of the folder that the file is in and then the tab name. Does this make sense?

 

[Andrew Poulsom]

That would be:

&[Path]&[Tab]