general cell question

[JohnE]

I know that you can place the name of the file (&[File])
into the header and footer of a worksheet. But is it
possible to do the same into a cell? If so, how would it
be done?
*** John

 

[Paul B]

John, try this
=MID(LEFT(CELL("filename", A1), FIND("]", CELL("filename", A1))-1),FIND("[",
CELL("filename",A1))+1, 255)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **

 

[DDM]

John, go to this page on Chip Pearson's website
http://www.cpearson.com/excel/excelF.htm#SheetName and scroll all the way to
the bottom to see how.

DDM
"DDM's Microsoft Office Tips and Tricks"
Visit us at www.ddmcomputing.com

 

[JE McGimpsey]

One way:

=MID(MID(CELL("filename",A1),1,FIND("]",CELL("filename",A1))),FIND("[",CE
LL("filename",A1)),255)