|
|
The following formula returns the workbook path of the workbook that
contains the reference A1...
=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1)&"[")-1)
Notes
- The argument "filename"
is literally the word "filename" within quotes.
- The workbook needs to
be saved, otherwise the formula returns empty text ("").
|
|
|
|
