Microsoft Office Tutorials and References
In Depth Information
Specifying variables using wildcard characters
Specifying variables using wildcard characters
You can use the wildcard characters ? and * to widen the scope of your searches. Wildcard
characters are helpful when you’re searching for a group of similar but not identical entries
or when you’re searching for an entry you don’t quite remember. Use them as follows:
The ? character takes the place of any single character in a Find What string. For
example, the Find What string 1?0 matches the values 1000, 190, 1900, 100A, Z1R0,
and so on. (This finds any entry that contains the search string, even if the entry is
part of a larger string.)
The * character takes the place of zero or more characters in a Find What string. For
example, the string 12* matches the entries 12, 120, 125, 1200000, and even 123
Maple Street.
You can use the wildcard characters anywhere within a Find What string. For example, you
can use the string *s to find all entries that end with s . Alternatively, you can use the string
*es* to find each cell that contains the string sequence es anywhere in its formula or value.
To search for a string that actually contains a wildcard character (? or *), type a tilde (~)
preceding the character. For example, to find the string Who? (including the question mark),
type Who~? as your Find What text.
Replacing what you find
Replace works much like Find—in fact, they open the same dialog box. When you click
Replace on the Find & Select menu on the Home tab (or press Ctrl+H), you see a dialog box
like the one in Figure 8-41. (If yours looks different, click Options to expand the dialog box.)
For example, to replace each occurrence of the name Joan Smith with John Smith, type
Joan Smith in the Find What text box and John Smith in the Replace With text box. You
can also find and replace formats using the dual Format buttons. For example, you could
search for every occurrence of 14-point bold and italic Times Roman and replace it with
12-point, double-underlined Arial.
To replace every occurrence of a string or formatting, click Replace All. Instead of pausing
at each occurrence to let you change or skip the current cell, Excel locates all the cells
containing the Find What string and replaces them.
Search JabSto ::




Custom Search