Is there a formula that will place the sheet name in a cell?

[Reed]

Is there a formula that will place the sheet name in a cell?

Thanks,

Reed

 

[Bob Phillips]

Reed,

Take a look at http://www.xldynamic.com/source/xld.xlFAQ0002.html

 

[Chip Pearson]

Reed,

Use the following formula:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99)

The file must have been saved once in order to work. Do not
replace "filename" with the file name. Use the formula exactly as
written.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Harald Staff]

Hi Reed

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

It's a little awkward, and it needs the file to be saved to work.

HTH. Best wishes Harald

 

[lightninbug]

Hello All,
Maybe I am missing something here but I am required to do this on all my
work on the job. Select the cell where you want the file name to appear then
type the formula -
=CELL("filename")
then hit enter.
Like I said maybe I missed a bit if information, wherein this longer more
complicated formula must be used.

 

[Bob Phillips]

Two problems..

1, it returns the whole path, file and sheet name, and the OP asked just for
the sheet name

2. you haven't anchored the formula to the sheet. Try this. Put that formula
in A1. Then go to another sheet, change the sheet name, go back to your
original sheet. Take a look at A1.

 

[lightninbug]

Thanks Bob - I knew there had to be a reason for the longer formula! I am
glad I asked : )

 

[Gord Dibben]

bug

Your formula returns the entire path,filename and sheetname.

OP wanted the sheetname only.

Also note what happens using your formula when you switch sheets then come
back to the original sheet.

Visit Bob's site for more info.

http://www.xldynamic.com/source/xld.xlFAQ0002.html


Gord Dibben Excel MVP