On Windows, you can specify non-breaking spaces in Excel formulas with
char(160), for example:
On Excel for Mac (2011), however,
char(160) maps not to the non-breaking space character, but to the "dagger" character, † (
What's a Mac-friendly way to specify non-breaking space? (this is probably very easy for anyone who knows what encoding Mac Excel uses and how to look up character codes)
I can input a non-breaking space with
opt-space, and Excel (so far) seems to treat it as a non-breaking space, but it's not great for readability - in a formula, it looks just like any space.
Bonus points for any answer that works consistently between Windows and Mac versions of excel - but for this question, Mac-only is enough