=MID(CELL("filename",A1), FIND("]", CELL("filename", A1))+ 1, 255)

Your file must be saved for this to work.

HTH,
Paul

"Bob" wrote in message
...
What is the formula to display just the worksheet name in cell? For
instance
the worksheet name is January 2007 and I would like January 2007 displayed
in
several areas within this worksheet. I am using Excel 2003.