Extract file name from formula

[Kevinax]

I have a formula linking to a separate file. I need to extract the file name as text. For example: formula says
=+'W:\test budget\[East.xlsx]2015 Budget'!$B$1
In the cell below I need 'East.xlsx

 

[Peter_SSs]

Why don't you enter in A1

=REPLACE(LEFT(CELL("filename",A1),FIND("]",CELL("filename",A1))-1),1,
  FIND("[",CELL("filename",A1)),"")

as suggested?

Aladin, I believe the OP wants to extract the name of the file the formula links to, not the name of the file that the formula resides in.


Kevinax
I don't think you will be able to do it in a single process without a macro. (It's a very simple one. )

 

[dhExcel]

Use the FORMULATEXT function.