MrExcel Publishing
Your One Stop for Excel Tips & Solutions

File location print on spreadsheet like word


Posted by John Hannifan on July 13, 2001 9:07 AM

Is there any way to make excel print the file name and location like you can in word?


Posted by Loren on July 13, 2001 12:12 PM

=LEFT(CELL("filename"),SEARCH("]",CELL("filename")))