find replace excel remove single character

[AlaskaBoy]

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.

 

[FiluDlidu]

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 ?

 

[MartinW]

Hi Alaska Boy,

? is a wildcard character
try it this way ~? in your find/replace

HTH
Martin

 

[AlaskaBoy]

So in the Find I tried putting ~? and it says it found nothing. What would I
put in the Find field?

 

[AlaskaBoy]

Forget my last question - got that to work. I had to clear the format.

Thank you, thank you, thank you.

 

[AlaskaBoy]

Yes, thank you - that worked. Thanks for your help.