How to Find and Replace Data in Excel

How to Find and Replace Data in Excel
Coming up next: How to Copy and Paste Data in Excel

You're on a roll. Keep up the good work!

Take Quiz Watch Next Lesson
 Replay
Your next lesson will play in 10 seconds
  • 0:01 Find & Select Tool
  • 0:30 Finding Information
  • 2:05 Find and Replace
  • 3:12 Using the Find Options
  • 3:50 Lesson Summary
Add to Add to Add to

Want to watch this again later?

Log in or sign up to add this lesson to a Custom Course.

Log in or Sign up

Timeline
Autoplay
Autoplay
Speed
Lesson Transcript
Instructor: Karen Sorensen

Karen has a Bachelors in Communications. She has 25 years of experience in Information Systems, Adult Learning and Virtual Training.

If you need to find a specific piece of information in a spreadsheet full of data, the search feature is mighty powerful. This lesson will guide you through how to use the Find and Find & Replace commands.

Find & Select Tool

One very powerful tool and option I use quite often is the Find & Select tool. You can quickly look for specific data and also choose to replace that data with something else.

What makes the Find & Select tool so powerful is that you can be very specific about where to look and exactly what to look for. This lesson will review and explain some of the features of the tool. We will take a look at the steps to performing a find, as well as a find and replace.

Finding Information

The best way to explain how the feature works is to start with an example worksheet. Imagine we have a spreadsheet of information that contains a list of sellers and their quarterly sales results for the year. There is a bit of information, including the results for each quarter and a year-end total.

You are a sales manager for one location, but the results are for all the sellers in the company, which has many locations. Your two sellers are in Billings, Montana: Liam Neeson and Burt Reynolds. Rather than scroll through the list to check their results, we can use the Find command to go directly to their record. Let's look at the steps.

  1. Go to the Home menu in the ribbon.
  2. Look in the Editing group of commands.
  3. Click on Find & Select and the drop-down menu will appear.
  4. Click on Find and notice that the Find & Replace window opens.
  5. Type the criteria for the search in the Find what box. In our example, we'll type Liam.
  6. Click on Find Next.

Excel immediately takes you to the first record it finds that is a match to your criteria and highlights the record. At this point, you can close the window or click Find Next to search for another record that matches. At any point, you can change the criteria and search for other information or a different record.

Find and Replace

Excel has a feature that lets you not only find text, but quickly replace it with other text. Let's go back to our example sellers and their quarterly results. One of the company branches is located in Boulder, Colorado. You know that the branch moved to Denver a couple of months ago, and you would like to change all instances of Boulder to Denver.

To unlock this lesson you must be a Study.com Member.
Create your account

Register to view this lesson

Are you a student or a teacher?

Unlock Your Education

See for yourself why 30 million people use Study.com

Become a Study.com member and start learning now.
Become a Member  Back
What teachers are saying about Study.com
Try it risk-free for 30 days

Earning College Credit

Did you know… We have over 200 college courses that prepare you to earn credit by exam that is accepted by over 1,500 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.

To learn more, visit our Earning Credit Page

Transferring credit to the school of your choice

Not sure what college you want to attend yet? Study.com has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.

Create an account to start this course today
Try it risk-free for 30 days!
Create an account
Support