By default, a center-justified row with the
Text format looks like:
I want the text to be center-justified in the cell and aligned by the first character, like:
And if it is right-justified:
The solutions are fairly simple with formulas or VBA, but can these 3 formats be accomplished with custom formats? And with a variable number of characters?