Replacing the "*" and "?" character, how?
Posted by Jeffery Ng on January 25, 2002 2:31 AM
Here's the situation.
I have a column with informaiton like this
TV Set 34 Inches
If I wanted to replace the * characters in Word, all I would have to do it type * into the replace dialog box. But with Excel * and ? are actually wildcard characters, so if I type * or ?, Excel assumes it's a wildcard instead of just the * that I'm looking for, so there's no way for me to easily remove all the * and ? from the column of data. What is a possible solution to this problem?
Can someone please help?
Thanks ahead of time!