Tab (Sheet) Name ?

  • Thread starter Thread starter Harold
  • Start date Start date
H

Harold

I was wondering if there is a way to dispay in Cell A1 The Name of the
Tab(Sheet) of that Sheet.

For Example I have a large WorkBook that has 10 Sheets, In Cell A1 of Each
Sheet I would like to see the Tab (Sheet Name) displayed in cell A1. Is
there a way to display in a cell the sheet name?

Thanks
Harold
 
Harold,

Try the following

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Harold said:
I was wondering if there is a way to dispay in Cell A1 The Name of the
Tab(Sheet) of that Sheet.

For Example I have a large WorkBook that has 10 Sheets, In Cell A1
of Each Sheet I would like to see the Tab (Sheet Name) displayed in
cell A1. Is there a way to display in a cell the sheet name?

Thanks
Harold
Click to expand...

Hi Harold
try the following - a little more than asked for :-)
File path and file name:
=CELL("filename",A1)

File path only
=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1),1)-1)

File name only
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CEL
L("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1)

The sheet name
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("file
name"
,A1),1))

HTH
Frank
 
Hi Harold

Provided the workbook has been saved, you could use
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename"
,A1)))
 
Back
Top