LEFT Function

Extracts a chosen number of characters from the start of a text string.

PUBLISHEDApr 06, 2026

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.

LEFT works best when the text structure is predictable. If every code starts with the same prefix length, the formula stays short and easy to audit. When the cutoff point changes from row to row, LEFT is often paired with FIND or SEARCH so the left portion can still be extracted accurately.

Purpose

Extract text from the start

Returns the first part of a text string based on the number of characters you request.

Return Value

A text string

Returns text. If you ask for more characters than the text contains, Excel returns the whole string.

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.

Function	Starts From	Use When
`LEFT`	The first character	The part you need is at the beginning
`RIGHT`	The last character	The part you need is at the end
`MID`	A position you choose	The part you need is in the middle
`FIND / SEARCH`	-	You first need the position of a separator

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"

Check Answer

Challenge #1

Target: Sheet1!B2

In cell B2, use LEFT to extract the first 5 characters from A2.

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)"

Check Answer

Challenge #2

Target: Sheet1!B3

In cell B3, use LEFT on A3 to extract the area code.

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."

Check Answer

Challenge #3

Target: Sheet1!B4

In cell B4, use LEFT on A4 to extract just the first letter.

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"

Check Answer

Challenge #4

Target: Sheet1!B5

In cell B5, use FIND and LEFT to extract everything before the hyphen in A5.

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

LEFT is the easiest text-extraction function when the part you need is at the beginning of the value. This lesson showed that it works especially well for fixed patterns like initials, prefixes, and area codes where the starting point never changes.

The main upgrade comes when you combine it with FIND. That makes LEFT useful even when the prefix length is not fixed, because the formula can locate the separator first and then cut the text at the right place automatically.

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.

Tactical Arena

Share LEFT Function!

Tell your friends about this post

Discussion