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?