Insert file name in Excel

  • Thread starter File name in cel
  • Start date
F

File name in cel

I want to insert the file name into a cel of my Excel Worksheet.
I need this for document management issues with Microsoft Business
Soltutions Axapta.

I work with Microsoft Office Excel 2003.
 
J

Jason Morin

=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))
+1,FIND("]",CELL("filename",A1))-FIND("[",CELL
("filename",A1))-1)

HTH
Jason
Atlanta, GA
 
Top