Excel 2010 Bible

Chapter 4: Working with Cells and Ranges

77

FIGURE 4.6

The Find and Replace dialog box, with its options displayed.

FIGURE 4.7

The Find and Replace dialog box, with its results listed.

Note
The Find and Replace dialog box allows you to return to the worksheet without dismissing the dialog box. n

The Find and Replace dialog box supports two wildcard characters:

l (^)? matches any single character.
l * matches any number of characters.