To use this function, choose Calc > Calculator.

Pads text with trailing spaces.



For text, specify the text or the column of text values. For num_chars, enter the total number of characters needed for the text and the trailing spaces. The padding is the total number of characters minus the number of characters in the text.


Column Calculator expression Result
C1 contains "excellent" PAD(C1,11) pads the word "excellent" with 2 trailing spaces