New answers tagged character
try char(202) instead of char(160). That seems to be the code in Excel Mac The reason is that your Excel Mac is working in the old MacRoman character set, where 160 is a dagger (U+2020) and 202 is a no break space (U+00A0) http://www.alanwood.net/demos/macroman.html
It's probably because the app continues to use the Chinese font for that character, and different fonts will often have slightly different glyphs for such symbols.
Top 50 recent answers are included