Search and Replace
 

Hi. I need to search for and replace words that have a "?" (question mark)
in them. For example, I want to change the word "util?ty" with the word
"utility". With a question mark in the search box, Excel 2003 reads it as a
letter in every word (as a wildcard). Thanks.

Use the following as your 'Find' criterion...

~?

Hope this helps!

In article ,
"Rebecca" wrote:

Hi. I need to search for and replace words that have a "?" (question mark)
in them. For example, I want to change the word "util?ty" with the word
"utility". With a question mark in the search box, Excel 2003 reads it as a
letter in every word (as a wildcard). Thanks.