How do I display the file name in the worksheet?

[Guest]

I want to display the file name in a cell in the workshett

 

[Guest]

To get the full file name including file path, type =cell("filename")

 

[Nick Hodge]

You will need to do some parsing to get the filename out, but this will give
you the whole reference of the path, filename and sheet

=CELL("Filename")

This give you just the filename

=MID(CELL("Filename"),FIND("[",CELL("Filename"),1)+1,(FIND(".",CELL("Filename"),1)+4)-(FIND("[",CELL("Filename"),1)+1))

(Beware the wrap above)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[Dave Peterson]

No matter which of the suggested formulas you use, you'll be better off to
include a cell reference in those formulas:

=cell("filename",a1)

If you fail to include a cell reference, then when excel recalculates, the
formula will evaluate using whatever worksheet/workbook is active.

(You can see this by using two workbooks, arranging the windows (window|arrange)
and putting:

=cell("filename")

in each window.

Then look at the opposite window.

 

[Guest]

Thanks! It Works! JKaz

To get the full file name including file path, type =cell("filename")