Formulas in Pathnames
There must be a reason you don't just edit it, but you don't say what. If
there are many instances, you could use the Find & replace option, Ctrl-H.
--
HTH
Bob Phillips
"SB1979" wrote in message
...
This is what I am trying to do:
e.g. A cell has the following reference:
='G:\Finance\Tax\7-1 Plan\P1
I want to change it to:
='G:\Finance\Tax\10-1 Plan\P1
so that '7-1 Plan' or '10-1 Plan' is the reference cell in another
workbook.
Thanks!
SB
|