To use this function, choose Calc > Calculator.

Pads text with trailing spaces.

Syntax

PAD(text,num_chars)

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.

Example

Column Calculator expression Result
C1 contains "excellent" PAD(C1,11) pads the word "excellent" with 2 trailing spaces
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy