LEFT Function in Excel: Extract Characters from Start
Returns the first character or characters in a text string, based on the number of characters you specify.
How to Extract Characters from the Left in Excel
The LEFT function returns the specified number of characters starting from the very first character on the left side of a text string.
Syntax & Arguments
=LEFT(text, [num_chars])
- text (Required): The text string containing the characters you want to extract.
- num_chars (Optional): The number of characters to extract (default is 1).
Examples
| Text (A2) | Formula | Extracted Result |
|---|---|---|
| "US-98234" | =LEFT(A2, 2) | "US" |
| "2026-Q3" | =LEFT(A3, 4) | "2026" |
Common Errors & Fixes
LEFT returns fewer characters than expected
Causes:- The cell contains extra spaces at the beginning (leading spaces).
- Non-printing characters exist before the visible text.
Fixes:- Use TRIM(A1) to remove leading spaces.
- Use CLEAN(A1) to remove non-printable characters before using LEFT.
Frequently Asked Questions
What does LEFT return if num_chars is omitted?
LEFT returns just the first character by default. So LEFT(A1) is the same as LEFT(A1, 1).
What happens if num_chars is more than the text length?
LEFT returns the entire text string. For example, LEFT("Hello", 10) returns "Hello" without any errors.
Does LEFT work in Google Sheets?
Yes, LEFT works identically in Google Sheets with the same syntax.
Related Formulas
Explore related formula generators to solve similar problems
🛠️ Related Tools
Want to become an Excel Pro?
Stop searching for formulas. Master Excel in 30 days with this top-rated course.
Learn More