That is not correct, you need to include a cell reference or else it will
switch sheet names
to the active sheet once the workbook is saved again.


--


Regards,


Peo Sjoblom


"Tom Hutchins" wrote in message
...
Try this...

="2008 " &
RIGHT(CELL("Filename"),LEN(CELL("Filename"))-FIND("]",CELL("Filename")))

The workbook must have been saved at least once for this to work.

Hope this helps,

Hutch

"FreddieP" wrote:

Hi I would like a formula in a cell where I can show the sheet name.

For example

="2008 "&"Sheetname"

Anybody who knows?