Show Sheet Tab Name in Cell

[scatman]

Hi,

does anybody know how to insert the title of the sheet tab into a cell on that sheet tab.

regards,

Paul.

[royUK]

You can get the full path, file name , sheet etc by using

=CELL("filename")

An array formula can return the sheet name only

=RIGHT(CELL("filename"),LEN(CELL("filename"))- MAX(IF(NOT(ISERR(SEARCH("\",CELL("filename"), ROW(1:255)))),SEARCH("\",CELL("filename"),ROW(1:255)))))

To enter a formula as an array formula, press CTRL+SHIFT+ENTER.

[Bob Phillips]

That's not just a sheet name, it iw workbook and sheet name.

The sheet name can be obtained more easily with

=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)

[scatman]

Cheers,

thanks for that.

regards,

Paul.

[Dave Hawley]

See also Return an Excel Worksheet Name to a Cell

BTW, a search would have resulted in MANY results as the question has been asked many times over.