Beyond the Help files . . .

  Lunarpages.com Web Hosting

 

Access  ¨  Excel  ¨ FrontPage ¨ Outlook ¨ PowerPoint ¨  Word ¨    Miscellaneous  ¨  Tutorials  ¨  Windows

Free Downloads    ¨   Suggest an Article    ¨    Fix an Article
 


 


 

Return the Workbook Name to a Cell in Microsoft Excel

Tip: In the formulas below, "filename" is exactly what you type, it's not something that means you're supposed to type your file name.

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

=SUBSTITUTE(SUBSTITUTE(LEFT(CELL("filename",A1),FIND("]",CELL("filename",A1))),"[",""),"]","")

 

Back to top...

 

 

All contents copyright Anne Troy 2005-2006