You can use another space character than the standard one. I have tested that the "no-break space" character behaves just like you want it to and according to what it is named.
Non-breaking space looks like a regular space Chr(32) but is a Chr(160)
So you could wrap any string in the Replace(CustomerName,' ',Chr(160)) and it will look the same but behave differently.
Here you can see a Pivot Table where the row #2 and 3 have non-breaking space instead of a regular space:
You can investigate the different spaces and their character codes with the Windows utility named CharMap:
Here I have searched for "Space" in the "Search for :" and found all characters that have "Space" in their character description. The first one that comes up is No-Break Space which is Unicode hexadecimal A0 which is decimal 160.