FCT

One method..........

EditReplace

What: =
With: xxxx

Replace all.

Copy the cells to the new worksheet and reverse the whole operation.

Also go back and reverse on source sheet.


Gord Dibben Excel MVP

On Mon, 12 Dec 2005 07:14:05 -0800, FCT wrote:

How do I copy a formula from one .xls file to another without having the old
.xls file references come into the new .xls file that I am copying to?


Solving this problem will save me a lot of time. Otherwise, I have to
retype the really long formula in the new .xls file.

Thanks--