You’ve already learned how to enter data into your form and you even know how to edit data that is already there. But, let’s look at a scenario:
It’s Monday morning and your boss just walked into your office to let you know your company is merging with another. Effectively immediately, your company is no longer called ABC Corporation. Now, you’re a member of XYZ Industries. Not to worry, though. Your paychecks will be uninterrupted because you’re the only one who knows how to quickly change every entry to reflect the new company name. Right?
It’s a good thing you’re taking this course because I’m about to show you how to tackle this project. We’re going to look at two different areas:
The Find feature quickly searches your form (field by field) for a specific word, phrase or data in your table. This is particularly useful when searching for data that appears more than once.
Figure 24. Find Dialog Box
Using Find to Locate Data
1. From the Home Tab, click Find in the Find Group
2. Enter your data in the Find What: box (such as ABC Corporation)
3. Set your options
4. Click Find Next
5. When you are finished searching your worksheet or workbook, click Cancel
The Replace feature actually works in conjunction with the Find feature by first searching for specific data and then replacing it with new data.
Figure 25. Replace Dialog Box
Using Replace to Modify Data
1. From the Home Tab, click Replace in the Find Group
2. Click Options to expand the Dialog Box
3. Enter your data in the Find What: Box (such as ABC Corporation)
4. Enter your data in the Replace With: Box (such as XYZ Industries)
5. Set your options
6. Click Replace or Replace All
7. When you are finished searching your worksheet or workbook, click Cancel