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.
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
The Regex only removes the sheet name, try
There is already the choice of File Name or Path/File Name for header or footer, see @koyotak answer