[fuzzylinux]

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

[JE McGimpsey]

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

[Gord Dibben]

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