2

On Windows, you can specify non-breaking spaces in Excel formulas with char(160), for example:

=A1&char(160)&A2
=substitue(cell_ref,char(160),"")

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

  • yup, Mac nbsp is opt/space – Tetsujin Apr 1 '15 at 13:37
2

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

1

This appears to be a problem with UTF-8 encoding in Excel 2011. See this article on GitHub Not much of a solution but may offer some insight. Adding a BOM (byte order mark) may help. This issue is specific to Microsoft Office applications and the UTF-8 encoding. See this discussion on Stackoverflow regarding Excel and UTF-8 encoding for more information.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .