Question regarding the ability to change multiple cells...

Deitrus

New Member
Joined
Jan 31, 2004
Messages
22
I have a question on how I could possibly change multiple cells within the same column that contain a number to a different number.

For example, I have a list of numbers in a column. The range is about 900 cells down that are all in Row A. I want to change all of the 1980 to 1936, ect. So I want to change every 1980 in that column to 1936. I also have a multitude of other years to change but I am just using this as an example. Is this possible and if so what would be the easiest and what would the formula be in order to achieve this?

Thank you.
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
58,315
Office Version
  1. 365
Platform
  1. Windows
Have you tried the "Replace" functionality in Excel?

Simply highlight the range you want to check, then from the Edit menu, select Replace and enter the value you want to Replace and the New value, then click "Replace All".
 

Deitrus

New Member
Joined
Jan 31, 2004
Messages
22
Wow, that was fast!!!

And that did the trick. Thank you so much for the help. :oops: :cool:
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
58,315
Office Version
  1. 365
Platform
  1. Windows
Glad to help! :biggrin:
 

Forum statistics

Threads
1,136,654
Messages
5,677,012
Members
419,668
Latest member
DharmaK

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top