ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do you display the sheet name in a cell? (https://www.excelbanter.com/excel-discussion-misc-queries/4118-how-do-you-display-sheet-name-cell.html)

Gerardo

How do you display the sheet name in a cell?
 
How do you display the sheet name in a cell?

Jason Morin

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))
+1,31)

Workbook must be saved to work.

HTH
Jason
Atlanta, GA

-----Original Message-----
How do you display the sheet name in a cell?
.


Gerardo



"Jason Morin" wrote:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))
+1,31)

Workbook must be saved to work.

HTH
Jason
Atlanta, GA

-----Original Message-----
How do you display the sheet name in a cell?
.

Thanks for the tip!!!



All times are GMT +1. The time now is 09:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com