I'd like to apply a custom cell formatting that takes an alphanumerical entry and outputs with predetermined visual spacing (no spaces in actual data). The purely numerical equivalent of what I'm trying to do would have a formatting code like this:
0000 0000 0000 0000
However, I'd like to have this apply to both text string as well as integers, but can't seem to figure out what the correct formatting code and syntax is?
The official help documentation states
@ for text string, but this seems to disregard the number of characters from what I can tell, as
@@@@ @@@@... seems to reprint the entire entry per-@. Hope to get some clarification on this, thanks!