R Rajeev Jul 2, 2003 #1 How do I make a formula for inserting the file name into a cell ie whenever i change the file name i need the cell updated. Thanx.
How do I make a formula for inserting the file name into a cell ie whenever i change the file name i need the cell updated. Thanx.
O Orlando Magalhães Filho Jul 2, 2003 #2 Hi Rajeev, Try this formula: =MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("file name",A1))-FIND("[",CELL("filename",A1))-1) HTH
Hi Rajeev, Try this formula: =MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("file name",A1))-FIND("[",CELL("filename",A1))-1) HTH
S Shah Shailesh Jul 2, 2003 #3 Hi, Use this formula posted by Rob Bovery. =MID(CELL("FileName",$A$1),FIND("]",CELL("FileName",$A$1)) +1,999) Works on a saved workbook.For unsaved workbook you may have to write UDF. See http://members.lycos.co.uk/ssweb/ Regards, Shah Shailesh
Hi, Use this formula posted by Rob Bovery. =MID(CELL("FileName",$A$1),FIND("]",CELL("FileName",$A$1)) +1,999) Works on a saved workbook.For unsaved workbook you may have to write UDF. See http://members.lycos.co.uk/ssweb/ Regards, Shah Shailesh
