MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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

Binford Furniture
DeskTop Oak
Chair Easy*********SP
Table Oak***SP
Rug Persian?????SP
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!


Posted by Stephen Hoadley on January 25, 2002 2:41 AM


use ~*

in the find replace box

Posted by Aladin Akyurek on January 25, 2002 2:47 AM


=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,CHAR(42)," "),CHAR(63)," ")," ","")

Copy down as far as needed.

=====================

Posted by jefferyng@hotmail.com on January 25, 2002 8:55 AM

Thanks so much!