How to Use LEFT in Excel
Extracts the first characters of a string — pull a prefix, area code or year out of a longer code.
What is LEFT in Microsoft Excel?
LEFT returns the beginning of a text value for however many characters you ask for. Combined with FIND or LEN it becomes a parser: split a code at a delimiter, isolate the first name in a full name, or grab the state prefix from a GST number.
Formula Syntax
Arguments Breakdown
| Argument | Requirement | Purpose & Details |
|---|---|---|
| text | Required | The string or cell to read from. |
| num_chars | Optional | How many characters to return from the start. Defaults to 1. |
When to Use LEFT (Real-World Business Scenarios)
- 1
Splitting a full name into first and last name parts.
- 2
Pulling a fixed-length prefix such as the first two characters of a state code.
- 3
Extracting everything before a delimiter when nested with FIND.
Step-by-Step Practical Business Example
Suppose you have the following dataset in Excel cells A1:D4:
| Full Name | First Name |
|---|---|
| Rahul Sharma | Rahul |
| Pooja Verma | Pooja |
| Aman Patel | Aman |
How it works: FIND locates the space at position 6, so LEFT returns the first 5 characters — everything before the space.
Common Errors & How to Fix Them
Why it happens: num_chars is negative, which happens when FIND returns 1 and you subtract 1 without guarding.
Fix: Wrap it: =IFERROR(LEFT(A2,FIND(" ",A2)-1),A2) so names without a space return in full.
Why it happens: num_chars was 0 or the source cell is blank.
Fix: Check the source and make sure num_chars is at least 1.
Try LEFT Live in Your Browser
No need to launch desktop Excel. Practice formulas with real-time feedback in our HyperFormula sandbox.
Frequently Asked Questions (LEFT)
What does the LEFT formula do in Excel?
LEFT returns the beginning of a text value for however many characters you ask for. Combined with FIND or LEN it becomes a parser: split a code at a delimiter, isolate the first name in a full name, or grab the state prefix from a GST number.
What is the syntax for LEFT?
What are common mistakes when using LEFT?
#VALUE!: num_chars is negative, which happens when FIND returns 1 and you subtract 1 without guarding. (Wrap it: =IFERROR(LEFT(A2,FIND(" ",A2)-1),A2) so names without a space return in full.) Result looks empty: num_chars was 0 or the source cell is blank. (Check the source and make sure num_chars is at least 1.)
Related Excel Formulas
Keep building your formula toolkit with these text functions.
- TEXTJOINJoins a whole range into one string with a delimiter you choose — the clean way to build comma-separated lists.
- TRIMRemoves leading, trailing and repeated spaces — the first fix for lookups that mysteriously return #N/A.
- SUBSTITUTEReplaces specific text inside a string — clean currency symbols, remove units or swap separators in bulk.
- LENCounts the characters in a cell, including spaces — the quickest way to catch invisible trailing whitespace.
- PROPERCapitalises the first letter of every word — fixes SHOUTED or all-lowercase names from raw imports.
- TEXTSPLITSplits one cell into many by a delimiter and spills the pieces into neighbouring cells — no Text to Columns needed.
Master LEFT in Basic Excel
Learn LEFT along with our formula library, practice files, and verifiable certificates in our complete curriculum.