Insert FILENAME and path

Question

How do I have Excel 2013 automatically insert the FILENAME and path information into a cell?

I can do this with Word 2013, { FILENAME \p \* MERGEFORMAT } - but most of Excel is way beyond me.

Thanks, Eric

Answer 1

Actually, I think =CELL("Filename") will also include the name of the sheet the formula is on as part of the result.  This will most definitely display the full filename and path:

=LEFT(CELL("Filename"),FIND("]",CELL("Filename")))

canvasAK note that if you enter an =CELL(".....") formula on a workbook that hasn't been saved to disc yet, nothing will appear in the cell. Only after saving and either refreshing the formulas or closing and reopening the book will the result show up.

Answer 2

How do I have Excel 2013 automatically insert the FILENAME and path information into a cell?

I can do this with Word 2013, { FILENAME \p \* MERGEFORMAT } - but most of Excel is way beyond me.

Thanks, Eric

Good information and formulas for this at Bob Phillips' site.

http://www.xldynamic.com/source/xld.xlFAQ0002.html

Note the caveats about adding a cell reference to the formulas when working with sheets

Gord

Answer 3

Help kind of stopped taking an active role sometime back around 2007, I think.  It either turned 66 and retired for real, or perhaps simply went on an extended vacation.

And that's what make the support forums so important - free help in real time, and sometimes it actually turns out to be true help!

Thanks for your feedback, very much appreciated.

Answer 4

Thank you all for your fast responses

This is what I was looking for but was having a dog of a time trying to find it in "Help."

Bob Phillips' site was also very useful ( http://www.xldynamic.com/source/xld.xlFAQ0002.html )

Thanks again, Eric

Answer 5

Eric,

=CELL("filename")

Regards,

Edwin Tam

Excel Power Expander - http://wwwv.vonixx.com