Lpad()

Home   Back   Next  

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"