Lpad()

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

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

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

Function Format

LPAD(string, length [, list]) 

Return Value

LPAD() returns a character string 

Examples

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

LPAD("APPLES", 10) = "    APPLES" 

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