take a look at the "Wildcard characters you can use to find text or
numbers" topic in XL Help. There you'll see that you need to prefix
asterisks (and question marks) with a tilde.



In article ,
Jan wrote:

We have some descriptions of parts that have an * (asterisk) in them
We need to find and replace the asterisk with a space or a dash,
but since the * is a wildcard character find and replace will not work
Any Suggestions?