It returns a certain amount of characters from the beginning of a string.
The syntax of the function is the following:
LEFT(text, [num_chars])
find_text: The text you from which the characters will come.
[num_chars]: Optional. The number of characters that will be returned. If it is omitted the default value of 1 will be used.
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here is an example of how to use the LEFT function:
Display the first three letters of the entries in the cell range A1:A20 in the respective cell range B1:B20.