A bug in excel

  • Thread starter Thread starter yma
  • Start date Start date
Y

yma

Hi,

I found a bug in excel 2000. I tried to replace all ? with 0 in a column.
It replaced all the cells to be 0, even the cells with other values that
were not ?.

Chris
 
? is a wild card. It's used to represent any character.

Try replacing ~? with 0. The tilde says to treat the question mark as a
question mark.

(Same kind of thing with asterisk (*).)
 
Why is that a bug? It has just done exactly what you asked it to do. :-)

? is a wildcard representing any character, so asking it to replace ? is the same as asking it to
replace every character.

Precede the ? with a ~ in the 'find what' box of the Edit / Replace dialog box.
 
Back
Top