Excel FunctionsLesson 90Free preview

LEFT

This lesson is part of Excel · All levels

Summary

LEFT is an Excel text function that takes a number of characters from the left side of a text. The syntax is LEFT(text, [num_chars]); if num_chars are passed, one character is taken. This function is useful for separating code or prefixes from the combined data.

Key points

Syntax: LEFT(text, [num_chars])
The number of characters is counted from the leftmost
If the num_chars exceed the length of the text, the entire text is returned
It can be combined with LEN and FIND to break down text.

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.