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

If this post helps click Yes
---------------
Jacob Skaria


"Curtis" wrote:

I believe there is a way to name a cell in a worksheet to equal the worksheet
name but I cannot recall

Is there?

Thanks