Hi,

An example of what you are trying to do would help but if I understand
correctly you might try copying the cell and then 'paste special' 'paste
values'.

The will replace the formula (=a1+a2) with the result of that formula.

Mike

"Octavio" wrote:

What is the way to leave the formula (sum, etc.) intact after erasing the
contents inside? Where I do set this?
Thanks in advance.