EXCEL: Set Cell Value as Tab Name
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:
Posted by Samson Loo
