|
|
The following formula returns the workbook name of the workbook that
contains the reference A1......
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,
FIND("]",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 the error #VALUE!
|
|
|
|
