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

Thanks,

Reed

Reed,

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

--
HTH

Bob Phillips

"Reed" wrote in message
...
Is there a formula that will place the sheet name in a cell?

Thanks,

Reed

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



"Reed" wrote in message
...
Is there a formula that will place the sheet name in a cell?

Thanks,

Reed

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


"Reed" skrev i melding
...
Is there a formula that will place the sheet name in a cell?

Thanks,

Reed

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.

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.

--
HTH

Bob Phillips

"lightninbug" wrote in message
...


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.

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

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

On Wed, 19 Jan 2005 16:59:03 -0800, "lightninbug"
wrote:



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.