Sorry,

for the sheet name, use:

=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1) )-FIND("]",CELL("filename"
,A1)))


Mangesh



"Mangesh Yadav" wrote in message
...
Use:

=CELL("filename",A1)

will give the full path. If you need just the file name, then use:


=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("file
name",A1))-FIND("[",CELL("filename",A1))-1)

Mangesh



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