Excel – Getting Worksheet Name

In Excel if you need to show, in a cell, the name of the worksheet use this:

First get the filename:

In Cell A1 enter    =Cell(“Filename”)

The result (in a saved file) will be something like:

C:\Users\Jon\Desktop\[Book1.xls]Sheet1

To get just the worksheet:

In another cell enter     =MID(CELL(“filename”,A1),FIND(“]”,CELL(“filename”,A1))+1,32)

August 24th, 2010