Put filename in a cell


G

Guest

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
 
Ad

Advertisements

G

Guest

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top