Sorry, wasn't precise enough.
The NBSP character for some codepages has value 160 (hex A0), so to use it with CHR() function you would need to enter CHR(160).

You also could use ALT+160 to get that character, and it seems also ALT+255 returns the same character of code value 160.