Dear Friends,

Is there a formula which would give me file name, sheet name, cell ref. separately from a formula.

e.g
A1 = +'G:\R COST CODE\2016-17\[R Cost Branchwise 1617.xlsm]225'!M4 (which is the formula)
B1 : R Cost Branchwise 1617.xlsm (which is file name)
C1 : 225 (which is sheet no.)
D1 : M4 (which is cell ref.)

In my day-to-day work, my file is linked to many files and each file has many many sheets.

The file is too heavy due to links
I plan to break the links by doing paste special formula, but retain there file name, sheet name and cell ref.

Please help.