Search and Replace Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top