I'm wanting to use mid and find functions to return the filename used within a formula link. The problem is that the find functions are looking at the linked value instead of the formula itself.

E.g.
Cell A1 Formula: ='C:\Directory\[File Name.xls]Sheet1'!$A$1
Cell A1 Returns: 3.3333

Cell A2 Formula: =MID(A1,FIND("[",A1)+1,FIND("]",A1)-FIND("[",A1)-1)
Cell A2 Returns: #VALUE!
What I'm wanting in A2: File Name.xls

When I look at the error report it says that it can't find "[" within 3.3333, which is true, but I'm wanting to find "[" in the full file name. Any suggestions? Thanks.