How to extract filename of a link

In an excel sheet, I would like to display in cell A1 the filename of the file that cell A2 is linked to. In cell A2 I display data from another file and would like the filename of that link to appear in cell A1.

Is there an easy way to do this?

Thanks

Marc

the ASAP utility has a function that will do that

www.asap-utilities.com