We are all familiar with the white question mark inside of a black diamond (�) when there is an encoding issue. Does this 'character' have an offical name? Or is it only referred to as the 'white question mark inside of a black diamond'? What would that name be if it has one?
3 Answers
It's the Unicode REPLACEMENT CHARACTER.
It's called "Replacement Character". See the related Wikipedia page.
2U+FFFD �: "replacement character" used to replace an unknown or unprintable character.
In Excel if the string "Women photographers � New Zealand" is in cell C5, then =SUBSTITUTE(C5,MID(C5,SEARCH("New",C5)-3,3),"--") will remove the replacement character to give you "Women photographers -- New Zealand".
2
