In order for this formula to work you need to make sure the workbook has been saved; otherwise, the cell will result in an error.
FORMULA:
=MID(CELL("filename",A1),FIND("]",CELL("filename"))+1,255)
VIDEO TUTORIAL:
Showing posts with label tutorial. Show all posts
Showing posts with label tutorial. Show all posts
EXCEL: Set Cell Value as Tab Name
Posted by
Samson J. Loo
Tuesday, January 20, 2009
at
2:50 PM
Subscribe to:
Posts (Atom)