So… Airtable is a dysfunctional platform in several different ways, and it does this VERY annoying thing that everybody universally hates:
Under some circumstances — but not all circumstances — Airtable will decide that it needs to cosmetically remove any extra spaces from your fields. If you type 2 spaces in a row into a text field, Airtable will cosmetically remove it. If you have an extra leading space, Airtable will cosmetically remove it. If you have more than one space in a row in certain formulas (but not all formulas), Airtable will cosmetically remove it.
As of now, the ONLY WAY to see the REAL TEXT THAT’S ACTUALLY THERE is to manually double-click within the individual field, and if it’s a formula field, you have to further expand the field after that. Then & only then will Airtable show you your actual text.
In other words, your extra space is actually there. You just can’t see it until you double-click into your field and then EXPAND the formula field. So it’s 3 clicks to see your actual data.
This dysfunction has caused countless headaches for people, in many different types of situations (sorting, grouping, printing, viewing, everything).
You would think that Airtable would care about displaying data with 100% integrity first & foremost, but nope. Welcome to the crazy & unpredictable world of Airtable!
I would highly recommend emailing email@example.com to ask them to please change this behavior.