Rpad()

Working with Formulas > Functions Used in Formulas > Text Functions > Rpad()

RPAD() adds the first character in the list to the right side of a string until the string is the specified length. If no characters are specified in the list, RPAD() adds spaces to the right side of a string until the string is the specified length.

RPAD() is similar to LPAD(), which adds characters to the left side of a string.

Function Format

RPAD(string, length [, list]) 

Return Value

RPAD() returns a character string 

Examples

RPAD("APPLES", 10, ".") = "APPLES...." 

RPAD("APPLES", 10) = "APPLES " 

RPAD("APPLES", 3) = "APP"