Path added to formula during copy

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear All,
I am using Win XP, and Office XP, when I copy one excel file to other disk
drive, a path of the source drive had been added to all formula in the cell
in the target file, but this is not the way I wanted. How to prevent the
automatic source added to the formula ? Thanks.
 
Select the range to copy
edit|Replace
what: = (equal sign)
with: $$$$$
replace all

Now all the formulas are plain old text.

Do the copy|paste

Then fix the original range and the pasted range:
Select the range
edit|replace
what: $$$$$
with: =
replace all

And the strings will be converted to formulas.
 
Back
Top