Pinterest Pixel

Find & Replace

The Find & Replace feature or CTRL+H shortcut allows you to amend your data in seconds.  Imagine... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

Find & Replace | MyExcelOnline

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 workbookFind-Replace.xlsx

 

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

Find & Replace

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

Find & Replace

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

Find & Replace

Click OK. Your values are now replaced

Find & Replace

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

See also  How to Insert an Excel Table

Find & Replace

The NORTH values are now removed!

Find & Replace

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

Find & Replace | MyExcelOnline

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!