Hi Mike
try the following formulas
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))
--
Regards
Frank Kabel
Frankfurt, Germany
Mike Schaus said:
Is it possible to automatically display a workbook name as text in a cell?
Is it possible to automatically display a worksheet name as text in a
cell?
