If you are amazed by what I have revealed yesterday, read on. Here is another application for the Find All function.
Let’s use the same list given yesterday. Instead of deleting the row, I will show you how to replace those cells with the statement “I want to replace this cell with this statement” in less than 10 seconds.
For those who did not have the list, it is given below. Please put them into a new worksheet.
internet marketing software
microsoft internet marketing
internet marketing filter
internet marketing program
free internet marketing
free internet marketing software
1. Highlight the list in the Excel Worksheet.
2. Go to Menu and select Edit, Find or use “Ctrl F” (shortcut key)
3. Type in the word “software”
4. Click on the “Find ALL” button
5. Select the list by
a) Go to the first item in the list.
b) Hold on the shift key and click on the last item in the list.
c) You have highlighted the entire list (See diagram)
6. Close the find and replace dialog box.
From here, type the statement “I want to replace this cell with this statement” into the Formula Bar. For those who do not know where is the formula bar, it is located just below the icons and to the right of the symbol fx.