Kornilios Ampatzis/ April 19, 2019/ Functions

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:

Practice

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.

Share this Post