Microsoft Office Tutorials and References
In Depth Information
Finding and Replacing Data
Click the Find Next button to conduct the search. The item might be found in
more than one location. Keep clicking Find Next (or pressing Alt+F) until you
find the item or you die of thirst on the hot sands of the digital desert.
Table 3-2
Wildcard Characters for Searches
Character
Description
Example
?
A single character
b?t finds bat, bet, bit, and but.
#
A single numeric digit
9411# finds 9 4111, 94112, 94113, and
so on.
*
Any group of consecutive
characters
t*o finds to, two, and tattoo.
[xyz]
Any character in the
brackets
t[aio]pper finds tapper, tipper, and
topper, but not tupper.
[!xy]
Any character not in the
brackets
p[!io]t finds pat and pet, but not pit
and pot.
x–z
Any character in a range
of characters
[1–4]000 finds 1000, 2000, 3000, and
4000, but not 5000. The range must
be in ascending order.
Book VII
Chapter 3
To quickly find the first value of a search term, start typing in the Search box
in the form window or in Datasheet view. As soon as you start typing, the
cursor moves to the first instance of the data you enter. The search box is
located at the bottom of the screen.
Finding and Replacing Data
Finding and replacing data is remarkably similar to finding data. The
difference is that you enter data in the Replace With text box as well as the
familiar Find What text box and other option boxes. Figure 3-5 shows the Replace
tab of the Find and Replace dialog box. Does it look familiar? If it doesn’t,
read the preceding topic in this chapter.
Figure 3-5:
Replacing
data.
Search JabSto ::




Custom Search