JE and Peo, thank you very much.

Greg
"Peo Sjoblom" wrote in message
...
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,34)

you can put this formula in any cell, even A1


Regards,

Peo Sjoblom

"GregR" wrote:

How do I get the sheet name in a cell. TIA

Greg