To use this function, choose .
Pads text with trailing spaces.
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.
Column | Calculator expression | Result |
---|---|---|
C1 contains "excellent" | PAD(C1,11) | pads the word "excellent" with 2 trailing spaces |