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

Regards
Rowan

"JaneC" wrote:

Hi, Is there a formula I can put in a cell that will show the name of the
sheet it is on? Thanks, Jane