Excel 97 wildcard question (repost)

I have a long list with * in it. I want to remove the asterisks. But since they are
a wildcard character, it finds everything. How can I find and replace a literal *?

awilliams3@carolina.rr.com previously answered this question correctly andI goofed and didn’t award him his points. This repost is so he’ll get his points. Incedentally, the answer is to preceed the wildcard character with a ~.