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?

Use ~* to find/replace *
~? to find/replace ?
~~ to find/replace ~


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?

--

Dave Peterson

have you tried ~*

--
Don Guillett
SalesAid Software

"Jan" wrote in message
...
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?

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?