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" |