Only works on a file that has been saved .....

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

Vaya con Dios,
Chuck, CABGx3



"DanD" wrote:

Is there a function to put the name of the file into a cell. I can see how
to put the filename into a header or footer but I would like it in the body
of the spreadsheet

Thanks
--
DanD