LEFT Function - Excel
Overview
The LEFT function in Excel is a useful tool for extracting a specified number of characters from the beginning (left side) of a text string.
Example:
=LEFT("Elephant", 3)
Syntax:
=LEFT(text, num_chars)
text: This is the text string from which you want to extract characters.
num_chars: This is the number of characters you want to extract from the left side of the text.
Example
In this example, the LEFT function returns the value “Hiki” because we plugged in the word “Hiking” into the function and selected that we only wanted to pull 4 characters from the left side.
