Freddie.

It works as Peo has written it.

I get 2008 Sheet1 when I enter the formula in any cell in Sheet1


Gord Dibben MS Excel MVP


On Fri, 16 May 2008 07:40:01 -0700, FreddieP
wrote:

I dont get it to work. And also I think that this will return the name of the
file. I want it to return the name of a specific sheet within the file.

Peo, could you perhaps write the formula in Swedish which I guess you are
when I see your name :)

/Freddie

"Peo Sjoblom" wrote:

="2008 "&MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)

A1 can be replaced by any cell reference even the cell that holds the
formula



--


Regards,


Peo Sjoblom


"FreddieP" wrote in message
...
Hi I would like a formula in a cell where I can show the sheet name.

For example

="2008 "&"Sheetname"

Anybody who knows?