Excel: Extract file name from formula

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

This question generated 11 answers. To proceed to the answers, click here.

This thread is current as of October 23, 2014.

For more resources for Microsoft Excel