View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
May May is offline
external usenet poster
 
Posts: 15
Default Adding Columns, Then deleting old columns

THANK YOU T TIPSY!

"T Tipsy" wrote:

Select your new numbers in column C and then edit/copy/paste special/values
in column A. Then delete columns B and C.

"May" wrote:

I want to add 240 to each cell in Column A (Column A + 240). Then I want the
new data to be the new Column A.

Right now I did: added Column B. Formulated 'Sum of Column A + Column B =
Column C' So, I wanted to make Column C to replace Column A. And delete
Column B. But the data keeps pulling the formula.

Please help! Thank you!