Changing entire column data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a quick question for anyone who can help. I have a large data set that
I need to convert. To explain this I have three columns with 450 data points
in each. In one of the columns I need to change each data entry by the same
amount. (x+25)/25. I am wondering if there is a way to have excel change each
point by that amount, rather than doing it by hand.
-Thanks in advance for the help
 
1. Key 25 and 1 in 2 open cells.
2. Copy the cell with 25.
3. Select the range of data to update
4. Go to Edit > Paste Special. Select "Divide". OK
2. Copy the cell with 1.
3. Select the range of data to update
4. Go to Edit > Paste Special. Select "Add". OK

HTH
Jason
Atlanta, GA
 
Back
Top