Search and Replace Question

[Rebecca]

Hi. How do I search for and replace parentheses, that is, "(" and ")"?

Also, is there a web site that lists all of these, such using ~* to search
for real asterisks?

[Dave Peterson]

There's nothing special about the parentheses. They should work just fine the
way you would do any other character.

(Do you have "Match entire cell contents" checked??? Or maybe you have some
formatting options set (xl2002+).)

~* for *
~? for ?
~~ for ~

If you search for "wildcard" in excel's help, you'll see these three.


Rebecca wrote:
>
> Hi. How do I search for and replace parentheses, that is, "(" and ")"?
>
> Also, is there a web site that lists all of these, such using ~* to search
> for real asterisks?

--

Dave Peterson