Pad will only evaluate the sides that you select. It will not pad characters in the middle of an input value.
It is possible to pad columns with spaces as the padding character as well.
Strip Blanks will remove the blank characters in a column before doing the pad. For example, the business unit column frequently has leading spaces. If you want those spaces to be maintained in the pad, uncheck the "Strip Blanks" check box.