Left()

Home   Back   Next  

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"