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.

DOWNLOAD WORKBOOK

Find & Replace2

 

 Helpful Resource:

MOTH-excel_expert470x63

 

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

Share on Google+

Related Posts

Excel Filter by Selection When you have an array of data in Excel you can quickly select an item and press the AutoFilter button which will filter that selection in your data.You can then go over to another column within your data and select another item, apply the same steps above and further filter ...
Autofill Formulas in an Excel Table One of the advantages of using an Excel Table is the ability to autofill a formula all the way down your data without having to copy and paste.When you write a formula anywhere in your Excel Table, it will automatically fill down and up within that column.As you add extra...
Show Averages With an Excel Pivot Table A Pivot Table is the most powerful feature within Excel as it allows you to analyze your data in many different ways, all with a press of a button.The Summarize Values By option allows you to choose a type of calculation (Sum, Count, Average, Max, Min, Count Numbers Produ...
Show The Percent of Parent Total With Excel Pivot ...  Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF PARENT TOTAL calculation.In the example below I show you how to get the Percent of a Product Total i.e The % Sales of each Product ...