Ltrim()

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

LTRIM() removes each character in the list from the left side of the string. When a leftmost character in the string matches a character in the list, the character in the string is removed. The process then repeats itself with all characters in the list, regardless of order, until no further leftmost characters in the string are present in the list. If the list is blank, LTRIM() removes spaces from the left side of the string. See examples below for further clarification.

LTRIM() is similar to TRIM(), which removes characters from the left and right sides of a string, and to RTRIM(), which removes characters from the right side of a string.

Function Format

LTRIM(string [, list]) 

Return Value

LTRIM() returns a character string 

Examples

LTRIM(" APPLES ") = "APPLES " 

LTRIM("APPLES", "A") = "PPLES" 

LTRIM ("APPLES", "AP") = "LES" 

LTRIM ("APPLES", "P") = "APPLES" 

LTRIM ("APPLES", "PA") = "LES" 

LTRIM("APPLES", "APS") = "LES" 

LTRIM("ABRACADABRA", "ABRC") = "DABRA" 

LTRIM("ABRACADABRA", "ABRCD") = ""