If the character is a question mark(?), then use ~?.

The question mark is a wild card. The tilde in front tells excel to really look
for that question mark character.

davids wrote:

is there a function i could use to find all the "™‚" characters in a
worksheet? a standard search does not work as excel returns an error messages
saying it can't find the data we're searching for

--

Dave Peterson