Search and Replace Question
 

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?

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