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.

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

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

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn