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

"JBeaucaire" wrote:

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" wrote:

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