Microsoft Office Tutorials and References
In Depth Information
Using wildcard find and replace
Meanings of wildcards for advanced searches
Any single character
h?t matches hat, hit, and hot, but does not match hart or hint
Any number of characters
h*t matches hat, hit, and hot, and also matches ht (inside height or weight), hart, hint, and
Any number of repetitions
of the preceding character
$1@. matches $1., $11., and $111. but does not match $121.
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,
<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
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-
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
(Soumya) (Singhi) matches Soumya Singhi, where each name can be referenced individually
\1, \2, and
Refer to the first, second, …
piece in the matched text
After finding (Soumya) (Singhi), the sequence \2, \1 in a replacement expression produces