CODEWITHSUNDEEP
excel-formula
Chelsea Owen
Chelsea Owen

Reputation: 3

Copying and pasting cells with formulas in them

I just used a substitute formula to remove spaces from a set of cells, I did this in column D, using data from column C, when I try to move the new data from D to C it does a substitute formula for column B?

Does anyone know how to prevent this?

Upvotes: 0

Views: 40

Answers (1)

James Chen
James Chen

Reputation: 237

You're pasting a formula, you need to paste values

enter image description here

Upvotes: 1

Related Questions