Excel LEFT Function (Characters From Start) – Examples & Practice
Practice the Excel LEFT function online with an interactive grid, instant feedback, and clear formula help.
Instruction
Extract the first 7 characters from text in A3.
Formula Syntax
=LEFT(text, [num_chars])
- text: The text string that contains the characters you want to extract.
- [num_chars]: Optional number of characters; defaults vary—specify explicitly in production sheets.
What it does
LEFT returns the leftmost characters from a text string. It is a core building block for parsing and standardizing codes.
Excel LEFT Function Examples
First 7 characters
=LEFT(A3, 7)
Returns a prefix slice from text in A3.
First character only
=LEFT(A3, 1)
Useful for status codes.
Prefix without overrun on short text
=LEFT(A3, MIN(5, LEN(A3)))
Never asks for more characters than the string contains—handy when vendor codes vary in length.
text-cleanup.xlsx
| A | B | |
|---|---|---|
| 1 | Raw Text | Helper |
| 2 | ACME Corporation | ACME |
| 3 | Invoice-2026-0001 | 2026 |
| 4 | VIP_CLIENT | VIP |
| 5 | John Doe | Doe |
| 6 | Product Name | Product |
| 7 | Output |
Input Formula
Need Help?
Tips
- Document num_chars rules next to the formula for auditors.
- Pair with VALUE if you need a numeric result from digits.
- Prefer Power Query for heavy parsing jobs.
LEFT Function Use Cases
- Extract area codes or prefixes
- Parse fixed-width identifiers
- Build sort keys from structured strings
- Prepare keys for VLOOKUP/XLOOKUP
- Split legacy concatenated fields
Common mistakes - LEFT function not working
- Wrong num_chars for variable-length data
- Forgetting TRIM when upstream data is messy
- Using LEFT when TEXT or DATE functions are clearer
- Off-by-one errors with inclusive character counts
- Assuming UTF-16 grapheme clusters behave like Excel characters in all cases
FAQ
What if num_chars is omitted?
LEFT returns the first character only in common defaults; specify num_chars explicitly to avoid surprises.
Does LEFT work on numbers?
Numbers are coerced to text using the cell’s displayed format.
LEFT vs LEFTB?
LEFTB counts bytes for double-byte character sets; LEFT counts characters.
Can LEFT parse fixed-width files?
Yes, often combined with MID and RIGHT for column splits.
Does LEFT trim spaces?
No. Use TRIM first if leading spaces exist.
Comparison
| Function | Slice |
|---|---|
| LEFT | From start |
| RIGHT | From end |
| MID | Middle segment |
Example
=LEFT("ABCDEF", 3) returns ABC.
Advanced examples
LEFT + FIND
Use FIND to locate a delimiter, then LEFT to extract the substring before it (common parsing pattern).