New answers tagged character
I think the issue you're facing is that the Character Viewer is no longer global, but is now per-app, so if you open it in, for instance, Safari, then switch to Finder, it will vanish. Open it again in Finder & its stored size, position & last viewed will be different. The advantage is you can keep it open in 2 different apps at the same time [with ...
I am not aware of any Character Viewer app that could be placed in the Dock (then again, I don't remember if I used this thing before Yosemite, though I think so). But in Settings > Keyboard you can find Show Keyboard & Character Viewers in menu bar so they are accessible. I agree it's handy at times, but to my knowledge, only apps and folders can be ...
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