move cell contents to another cell without affecting the formatting of either cell

Copper Contributor

Im looking for a solution to be able to move the contents of a cell, to another cell, without affecting the formatting of either cell. An example is moving 

2 Replies

@Lazaroni 

In the first step you can copy the Source Cell and paste it as Values into the Target Cell and then delete the Source Cell content simply pressing the Delete key from the keyboard.

HI@Lazaroni 

You can achieve this by copying the original cell and then do a paste special (Alt + E S V) and again copying the original cell and do a format paste (ALT + E S T).

I hope this will solve.