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

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"FreddieP" escreveu:

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

For example

="2008 "&"Sheetname"

Anybody who knows?