Sheet name in a cell

[KevinR]

Is there a way to bring the name of the worksheet into a cell on the worksheet?

 

[Dave Peterson]

Debra Dalgleish shares how:
http://contextures.com/xlfaqFun.html#SheetName

 

[Chip Pearson]

Use a formula like

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

In this formula, use the word "filename" as shown. Don't substitute
the actual file name. The reference A1 can be any cell -- it doesn't
matter. The name of the sheet on which that cell resides will be
returned.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[muddan madhu]

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