Finding a filename within an excel worksheet

J

John Weidenfeller

How can I go about automatically inserting a filename of a worksheet into a
cell??

Thanks
John
 
F

Frank Kabel

Hi John
try one of the following formulas (note: the workbook has to be save
before)
File path and file name:
=CELL("filename",A1)

File path only
=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1),1)-1)

File name only
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CEL
L("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1)

The sheet name
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("file
name",A1),1))
 
Top