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).


Feedback