Pad > justify
Use the Justify property to specify whether the data is padded to the left or right.
- Left
- The data will be on the left and will be padded (if necessary) on the right.
- Right
- The data will be on the right and will be padded (if necessary) on the left.
Use the TRIMLEFT and TRIMRIGHT functions to exclude pad characters from the justified side.
In the following
example, xxxxxxxxxx represent 10 spaces:
For an input of 1234567891xxxxxxxxxx with a right
justified pad, the rule =SIZE(input) returns 20.
For the same input, the rule =SIZE(TRIMRIGHT(input)) would
return 10 (removing the padding on the right).