View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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