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