how to insert the path and filename into cell in excel 2002
 

how to insert the path and filename into cell in excel 2002

how to insert the path and filename into cell in excel 2002
 

See

http://www.mcgimpsey.com/excel/formu..._function.html

In article ,
fuzzylinux wrote:

how to insert the path and filename into cell in excel 2002

how to insert the path and filename into cell in excel 2002
 

Copied from Bob Phillips' site........note: leave the "filename" as is. Do not
substitute your file name.

File path, file and worksheet 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("]",CELL("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1)

The sheet name:
=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)

Restrictions
This technique only works for workbooks that have been saved, at least once.

http://www.xldynamic.com/source/xld.xlFAQ0002.html for more details if you need
them.


Gord Dibben MS Excel MVP

On Wed, 4 Jun 2008 12:31:03 -0700, fuzzylinux
wrote:

how to insert the path and filename into cell in excel 2002