Home > Articles > Home & Office Computing > Microsoft Applications

  • Print
  • + Share This
This chapter is from the book

This chapter is from the book

Replacing Data

Imagine that you discover some data in your table in which a company’s name has been consistently misspelled, or that a salesperson you reference in a data table has changed his last name. You definitely would not want to find and replace all that data manually. Fortunately, Excel enables you to search for instances of incorrect or outdated data and replace it with new data using its Find and Replace feature.

start.jpg

circle_1.jpg On the Home tab, click Find and Select and then click Replace.

circle_2.jpg In the Find What text box, type the data you would like to find. Press the Tab key to move the cursor to the Replace With text box, and type the replacement data.

circle_3.jpg Click Replace All to replace all instances of the data you typed. (Alternatively, click Find Next to find the first instance of the data and click Replace to replace it.)

circle_4.jpg Excel notifies you of the number of replacements it made. Click OK.

end.jpg
  • + Share This
  • 🔖 Save To Your Account