I am trying to force a space-symbol " " into a set of formulas that use emojis to represent “done” () and am having trouble where many of them next to each other get “smushed” even though I specifically have them set up to be pulled from a table with symbols in it to designate how many checkmarks to put.
I have the checkmark in a table by itself with two spaces after it in order to use this in repeat() functions to designate how many to use; However when I do that the spaces after the emoji seem to get deleted. I’ve tried using concatenation to define the spacebars (i.e. =concatenate(“”,character(32)) but this doesn’t seem to work, even though it should appear like this: it always ends up like this: which just isn’t the aesthetic I’m going for.
I can work up a quick doc if helpful, but just wondering if anyone has tips on how to preserve the space “symbol” so that this isn’t an issue? I’ve tried the transmuting the trick for carriage returns where you use a table with an inserted space as its own cell as well, to no avail!