Insert file/path in Spreadsheet

Is there a way to insert the file name and path in a spreadsheet? If yes, what is it?

another opinion: to put in the headline and/or the footline of the sheet(s) several expressions such as page of pages, author, file-name, datum …, that is only visible by printing or exporting.

1 Like

Try Formula:


Thank you; I will give it a try.

Cool. Tried it and worked. This is a frequent addition to documents in Enterprise Operations where directory structures can get quite elaborate.

Suggestion to the developing community – create a formula that contains this function and call it PATH. Most spreadsheet users will never delve into the universe of Regular Expressions :slight_smile:

The Regex only removes the sheet name, try =CELL("filename")

There is already the choice of File Name or Path/File Name for header or footer, see @koyotak answer

1 Like