Was looking into creating some formula to make sure that a concatenation of texts will always look the same on a switch.
Ended up using A1&REPT(" ", 15-LEN(A1))
This made sure that A1 always ends up being 15 characters long.
Maybe there are better ways?
No comments:
Post a Comment