find replace excel remove single character
 

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.

find replace excel remove single character
 

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.

find replace excel remove single character
 

Hi Alaska Boy,

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

HTH
Martin


"AlaskaBoy" wrote in message
...
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.

find replace excel remove single character
 

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

"FiluDlidu" wrote:

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.

find replace excel remove single character
 

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

Thank you, thank you, thank you.

"FiluDlidu" wrote:

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.

find replace excel remove single character
 

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

"MartinW" wrote:

Hi Alaska Boy,

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

HTH
Martin


"AlaskaBoy" wrote in message
...
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.