Left()

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

LEFT() returns a specified number of characters from a string, starting with the left-most character. If the specified length exceeds the length of the string, the entire string is returned.

Function Format

LEFT(string, length) 

Return Value

LEFT() returns a character string 

Examples

LEFT("APPLES AND ORANGES", 5) = "APPLE" 

LEFT("APPLES AND ORANGES", 10) = "APPLES AND" 

LEFT("APPLES AND ORANGES", 20) = "APPLES AND ORANGES"