=MID(CELL("filename"),FIND("]",CELL("filename"),1)+1,5)
=LEFT(IF(ISERROR(RIGHT(CELL("filename",$A$1),LEN(CELL("filename",$A$1))-FIND("]",CELL("filename",$A$1)))),"This workbook never saved",RIGHT(CELL("filename",$A$1),LEN(CELL("filename",$A$1))-FIND("]",CELL("filename",$A$1)))),5)
Open in new window
This will give you the sheet name if your workbook is saved..
Saurabh...