Function to display file name

  • Thread starter Thread starter Elton Law
  • Start date Start date
This formula only works after the file has been saved at least once...in any
cell:

=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,(FIND("]",CELL("filename",A1))+1)-FIND("[",CELL("filename",A1))-2)
 
Hi Rocket Scentist,
Terrific, it works ... Thanks indeed.
Elton

JBeaucaire said:
This formula only works after the file has been saved at least once...in any
cell:

=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,(FIND("]",CELL("filename",A1))+1)-FIND("[",CELL("filename",A1))-2)

--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.


Elton Law said:
Hi Expert,
Is there a function to display the file name in cell please?
Thanks
Elton
Click to expand...
Click to expand...
 
Back
Top