I have a column of cells that contain prices and what I want to do is apply to each cell in the column a percentage increase.
I can apply a formula to increase the value and put the result into an adjacent cell in an adjacent column but then what I want to do is delete the original column. However when I go to delete the original column of cells, the values in the new column of cells are lost.
As long as your formula is linked to the original cell, it updates every time to change or in your case delete the value. You could copy the result of your formula and paste as values, then it wouldn't be linked to the original cell anymore, would that work for you?