Can I copy formulas "as they are" when they are not static

S

Sirritys

Hi,

I have numerous cells with formulas in them, and I would like to
transfer them to other location without formulas changing.

They need to be dynamic before and after, but not during this transfer

Don't ask me why ;-)

-Sirritys
 
N

Niek Otten

Find and replace all "=" with "~", move and change back

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi,
|
| I have numerous cells with formulas in them, and I would like to
| transfer them to other location without formulas changing.
|
| They need to be dynamic before and after, but not during this transfer
|
| Don't ask me why ;-)
|
| -Sirritys
|
 
H

Harlan Grove

Niek Otten wrote...
Find and replace all "=" with "~", move and change back
Click to expand...

Unwise to use ~ since it's a metacharacter. In order to change literal
~s back to =s, you'd need to replace ~~ with =. Better to use any
character other than ~, ? or *.
 
P

Pete_UK

I usually change "=" to "xyz=" and then back again after I've copied
them.

Pete
 
D

Dave Peterson

And one more to avoid--apostrophe (').

I use $$$$$=
but only if I know that $$$$$= is never used elsewhere.
 
Top