Excel Character Question Mark In A Box

[themusicbox]

Hi I've searched for this in the forums but can't find anything. I need to find/replace a character in Excel, it's a question mark in a box and looks like this

I've tried searching for special characters (using the ALT key and number pad) but I can't find anything matching this.

When I save the spreadsheet as a CSV (TAB delimited) this character gets picked up as a TAB, but when I try find replace on the TAB character it doesn't work!

I'm using Excel 2007.

Please help!!

 

[Costasenos]

Complement:
If you are treating text strings that you want to have separated into different columns, I suggest applying to formula hereunder to the entire column:

SUBSTITUTE(A1;CHAR(13);"XXXXX")

Replace XXXXX in this formula by whatever character you find more appropriate for your treatment.

Dale

 

[gothic chicken]

Hi I've searched for this in the forums but can't find anything. I need to find/replace a character in Excel, it's a question mark in a box and looks like this

I've tried searching for special characters (using the ALT key and number pad) but I can't find anything matching this.

When I save the spreadsheet as a CSV (TAB delimited) this character gets picked up as a TAB, but when I try find replace on the TAB character it doesn't work!

I'm using Excel 2007.

Please help!!

Ten years later...
In Excel if the string "Women photographers � New Zealand" is in cell C5, then =SUBSTITUTE(C5,MID(C5,SEARCH("s ",C5)+1,3),"--") will remove the replacement character to give you "Women photographers -- New Zealand".

 

[gothic chicken]

Here's the website you're after: How to remove the diamond with question mark symbol