Pasting formulas but not the links help needed

[zilla37]

How can I paste a formula onto a seperate spreadsheet from a template I
made but not have the link from the template included in the formula?

 

[Dave Peterson]

If it's just one cell, I copy it from the formula bar and paste into the formula
bar.

If it's a bunch of cells, I do this:

Select the range to copy
edit|Replace
what: =
with: $$$$$
replace all

Do the copy|paste while my "formulas" are just text.

Tnen reverse it (in both locations).
edit|Replace
what: $$$$$
with: =
replace all

And the Text formulas will change back to formula formulas.

 

[Zilla]

It works. Thanks for the help

If it's just one cell, I copy it from the formula bar and paste into the formula
bar.

If it's a bunch of cells, I do this:

Select the range to copy
edit|Replace
what: =
with: $$$$$
replace all

Do the copy|paste while my "formulas" are just text.

Tnen reverse it (in both locations).
edit|Replace
what: $$$$$
with: =
replace all

And the Text formulas will change back to formula formulas.