P
Parish
Hallo!
Question for y'all! Say I have a cell, A1, which has the
following link..
='S:/blah/[test.xls]sheet1!$B$4
Now I want another cell, C2, to display the name of the
excel file in which cell A1 is referencing.
I was figuring on using some combination of mid function
and search functions to isolate the name of the excel
file, but ...
HOW DO I REFERENCE AN ELEMENT OF THE FORMULA IN ANOTHER
CELL, WITHOUT REFERENCING THE VALUE OF WHAT THE LINK
RETURNS?
even like a =mid(a1,6,4) will only show the 6th thru 9th
characters of the VALUE of cell A1, not "blah", which is
the 6th - 9th characters of the formula itself.
Any ideas???
Question for y'all! Say I have a cell, A1, which has the
following link..
='S:/blah/[test.xls]sheet1!$B$4
Now I want another cell, C2, to display the name of the
excel file in which cell A1 is referencing.
I was figuring on using some combination of mid function
and search functions to isolate the name of the excel
file, but ...
HOW DO I REFERENCE AN ELEMENT OF THE FORMULA IN ANOTHER
CELL, WITHOUT REFERENCING THE VALUE OF WHAT THE LINK
RETURNS?
even like a =mid(a1,6,4) will only show the 6th thru 9th
characters of the VALUE of cell A1, not "blah", which is
the 6th - 9th characters of the formula itself.
Any ideas???