The Find & Replace feature or CTRL+H shortcut allows you to amend your data in seconds.  Imagine you had thousands of rows of data that was downloaded from an external system with the wrong date.  A simple CTRL+H will save you heaps of time!  See how below.

YouTube video

Find & Replace | MyExcelOnline

DOWNLOAD WORKBOOK

 

STEP 1: Let us try replacing the years 2015 with the year 2021. Select all of the Order Dates

Find & Replace | MyExcelOnline

STEP 2: Go to  Home > Find & Select > Replace

Find & Replace | MyExcelOnline

STEP 3: We want to replace 2015 with 2021. Type that in, then click Replace All

Find & Replace | MyExcelOnline

Click OK. Your values are now replaced

Find & Replace | MyExcelOnline

STEP 4: You can also use it to remove values. Let us say we want to remove the NORTH Region

Select the values of the REGION Column. Go to  Home > Find & Select > Replace

Type in the values to find the NORTH text and replace it with a blank. Click Replace All

Find & Replace | MyExcelOnline

The NORTH values are now removed!

Find & Replace | MyExcelOnline

HELPFUL RESOURCES:

JOIN OUR FREE EXCEL COURSES BELOW
Click here to access these FREE Excel courses!

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin