Authored By: Billie Hardison
In our continuing series of Microsoft Excel tips and tricks that I have gathered over the years, today we consider the “find & replace” functions in Excel. Many people use the “Find” feature in Excel to find a word or phrase that they are looking for. Do you ever use the “Replace” feature? This tool can come in handy when manipulating data.
To use the “Find” feature in Excel, simply hold down the control button on your keyboard and hit “F”. Here you can type in a word, any part of a word, or a phrase to find data. There is an additional tab in this window called “Replace”. Click on this tab and enter the word or phrase you would like to replace in the “Find what:” box. Then type the phrase you want to replace it with in the “Replace with:” box. You can replace every occurrence or you can replace the word one instance at a time.
What most people don’t realize is that this tool can be used to remove unwanted data from your spreadsheet.
Let’s say you export a list of names from your accounting software, but all of the names have some sort of appendix on them, like “xx”. Use the find and replace function to find “xx” and replace it with……nothing! Now, you have just removed the unwanted data from your file!
Be Careful: If you are replacing data, make sure you don’t replace anything that should be kept. In the example above, a person named Alexxa in the list would have the xx’s removed from the name.
If you are an Advocate Capital customer and need help preparing or manipulating data in the Excel application, feel free to contact me at BHardison@AdvocateCapital.com.
Here at Advocate Capital, Inc., we are not your everyday lender. We offer unlimited training to all our customers in a variety of applications. This is just one of the many reasons you should become an Advocate Capital client today!
Photo Credit: Dmitriy Shironosov