Microsoft Office Tutorials and References
In Depth Information
Using wildcard find and replace
Meanings of wildcards for advanced searches
Wildcard
Meaning
Example
?
Any single character
h?t matches hat, hit, and hot, but does not match hart or hint
*
Any number of characters
(including zero)
h*t matches hat, hit, and hot, and also matches ht (inside height or weight), hart, hint, and
halftone
@
Any number of repetitions
of the preceding character
(including zero)
$1@. matches $1., $11., and $111. but does not match $121.
^13
A paragraph mark (ASCII 13)
.^13 matches a period at the end of a sentence, followed by a paragraph mark (¶).
< >
The start and end of a word,
respectively
<ful matches fully and fuller, but not artful
eight> matches height and weight but not eighth
[ ]
Any character from a sequence
or range of characters inside
the brackets
h[ai]t matches hat and hit, but does not match hot or hut
[A-Z] matches any single uppercase letter, and [a-z] matches any single lowercase letter.
[A-Za-z] matches any letter.
[! ]
Any character except those in
the sequence or range of char-
acters following the exclama-
tion mark
h[!ou]t matches hat and hit as well as h1T and h%t, but does not match hot or hut
( )
Divide the search expres-
sion into pieces that can be
referenced in a replacement
expression
(Soumya) (Singhi) matches Soumya Singhi, where each name can be referenced individually
\1, \2, and
so on
Refer to the first, second, …
piece in the matched text
After finding (Soumya) (Singhi), the sequence \2, \1 in a replacement expression produces
Singhi, Soumya
Search JabSto ::




Custom Search