Function to display file name

[Elton Law]

Hi Expert,
Is there a function to display the file name in cell please?
Thanks
Elton

 

[JBeaucaire]

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)

 

[Elton Law]

Hi Rocket Scentist,
Terrific, it works ... Thanks indeed.
Elton

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.

Hi Expert,
Is there a function to display the file name in cell please?
Thanks
Elton