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 |