EXCEL: Set Cell Value as Tab Name

Posted by Samson Loo Tuesday, January 20, 2009 at 2:50 PM

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:

Labels: , ,

1 comments:

Rajib Bahar January 28, 2009 6:17 PM

thanks for the tip.

rajib

Post a Comment

Subscribe to: Post Comments (Atom)