How to specify non-breaking space on Mac Excel - Mac version of char(160)
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