The question mark is a joker that replace any character (including itself).
To limit its range of action to only genuine question marks, use ~? instead
of ?

"AlaskaBoy" wrote:

Excel 2007.

Big spreadsheet. 15000 rows.

One column has for some reason randomly added a question mark at the end of
a bunch one word text in this column (they're brand names). I want to
replace the ? with a blank space. When I do it, though, I end up with a
blank cell.

There must be a way to just take out all the question marks in column B.
What am I missing?

Thanks.