general cell question

  • Thread starter Thread starter JohnE
  • Start date Start date
J

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
 
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 **
 
One way:

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