Summary

The Excel LEFT function returns characters from the beginning of a text string. You choose how many characters to take, and Excel starts from the left side. For example, =LEFT("EC-101",2) returns "EC".

LEFT is useful when the part you need is always at the start of the value. Common examples are prefixes, initials, area codes, and the first part of a structured code. When the length is fixed, LEFT is enough on its own. When the length changes, you usually combine it with FIND or SEARCH.

Syntax

=LEFT(text, [num_chars])

The first argument is the text to extract from. The second argument is how many characters to return. If you leave num_chars out, Excel uses 1, so =LEFT(A1) returns only the first character.

Arguments

• text - [Required] The cell or text string you want to extract from.
• num_chars - [Optional] The number of characters to return. The default is 1.

LEFT vs Other Functions

LEFT, RIGHT, and MID all extract text, but they start from different positions. LEFT starts at the beginning, RIGHT starts at the end, and MID starts from any position you specify.

Using LEFT

If every value follows the same pattern, LEFT is simple. A formula like =LEFT(A1,3) can return a three-letter code from every row. This is common with product prefixes, class codes, and short identifiers.

If the length is not fixed, LEFT becomes more useful when paired with FIND. For example, =LEFT(A1,FIND("-",A1)-1) returns everything before the first hyphen. Because FIND locates the hyphen first, the formula still works even when the prefix length changes.

• Use LEFT(A1,n) when the number of characters is always the same.
• Use LEFT(A1,FIND("-",A1)-1) when the text ends at a separator.
• Use LEFT(A1,1) when you only need the first letter.

Example 1 - Extracting a Fixed Number of Characters

This is the basic LEFT pattern. Excel starts at the first character and returns the number of characters you specify. It works best when the structure is consistent across the whole column.

=LEFT("ExcelClash", 5)  // "Excel"
=LEFT("ENG-2026", 3)    // "ENG"
=LEFT("EC-101", 2)      // "EC"

Example 2 - Pulling an Area Code from a Phone Number

When the area code always appears at the start in the same format, LEFT can extract it directly. Here the first five characters are (212), so that is what the formula returns.

=LEFT(A1, 5)   // "(212) 555-0101" -> "(212)"

Example 3 - Getting the First Letter from a Name

If you set num_chars to 1, LEFT returns only the first character. This is useful for initials, short labels, or checks based on the first letter of a value.

=LEFT(B2, 1)     // "John Smith" -> "J"
=LEFT(B2, 1)&"." // "J."

Example 4 - Extracting a Variable-Length Prefix Dynamically

When the prefix length changes, LEFT alone is not enough because you do not know how many characters to take. In that case, FIND returns the position of the hyphen, and LEFT uses that result to cut the text at the correct point.

=LEFT(C1, FIND("-",C1)-1)
// "MTL-005" -> finds "-" at position 4 -> returns "MTL"

LEFT works on text, but Excel will also apply it to numbers and dates by first converting them to text. That can be useful, but it can also produce results that look odd if you expected numeric behavior. It is best to use LEFT when you are clearly working with text-based values or text-like codes.

• LEFT is best when the needed part is at the beginning of the value.
• Use FIND or SEARCH with LEFT when the cut point depends on a separator.
• Use RIGHT for text at the end, and MID for text in the middle.

Conclusion Recap

• Summary: LEFT returns characters from the beginning of a text string.
• Syntax: =LEFT(text, [num_chars]).
• Key point: If num_chars is omitted, Excel returns just the first character.
• Practical usage: Prefixes, initials, area codes, and text before a separator.
• Best pattern: Combine LEFT with FIND when the prefix length is not fixed.