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:
This article includes the following tags:
- Microsoft Excel