You have a couple of responses that suggest paste specialvalues, which is the
way to go in your case.

For future you may want to try this method of adding the 10 to each cell.

Enter 10 in an unused cell.

Copy that cell.

Select your range in Column A and Paste SpecialAddOKEsc.

Clear the cell with the 10.

No need for a column B.


Gord Dibben MS Excel MVP

On Tue, 4 Jul 2006 02:47:16 -0500, krcc
wrote:


hey
i have a column (A) and a constant, for example 10. i add this constant
10 to each row of the column A and get a new column (B). how can i
delete the old column A (to which i added 10) but still have the
results saved in column B? since column B has the formula =A1+10 when
i delete column A i am left with 10 for column B because it is now
adding 0+10 for each row. thanks
kc