Buzz
The search and replace operation helps you save a considerable amount of time and effort when working on spreadsheets containing thousands of data entries. However, not everyone knows how to do this. The method below can be applied to Office 2013, Office 2010, Office 2007, and Office 2003 versions.
Guide to Finding and Replacing in Excel Spreadsheets
Performing Search in Spreadsheet
Step 1: Open the excel file you want to search, in the home tab, select Find & Select -->Find (ctrl+F)
Step 2: A dialog box appears, type the text you want to search into the Find What box, for example, here I want to find the number 3000000.
+ Find next to search for each word sequentially.
+ Find all to find all occurrences, the search results will be displayed as shown in the image below
Replacement in Spreadsheet
Step 1: Open the Excel file you want to apply replacements to, in the Home tab, select Find & Select --> Replace (ctrl +H).
Step 2: A dialog box appears, type the word you want to replace into the Find What box, type the replacement word into the Replace with box.
Where:
+ Replace: Sequentially replace each word
+ Replace All: Replace all. A dialog box will appear notifying you of how many results have been replaced
Result: The replacement cell will be marked as shown below
With this search and replace tool, it will greatly assist you, saving you time, accurately manipulating lengthy spreadsheets.
