TLDR:
Concatenated text shown in the formula field depicts consecutive spaces as a single space. The real, complete, result of the formula only shows up in the expanded cell view (or, as I learned, when you copy and paste out of the ‘abridged’ formu...