Ravindra BagaleCourses & study guides Track your progress

Excel LEFT Function

By · Last updated:

Chala mitrano — lEFT is scissors from the start. Say how many letters from the left.

Fictional sample data for learning. Bank IFSC / product codes (Nashik + Dublin). Mixed ₹ and €.

Purpose

Return the first (leftmost) characters from a text string. Ideal for fixed prefixes such as bank codes and brand letters.

Return value

A text string with the characters you asked for from the left.

Syntax

LEFT(text, [num_chars])

Arguments

ArgumentRequired?Description
textRequiredThe text or cell with the full string.
num_charsOptionalHow many characters from the left. Default 1.

Version

All Excel versions. LibreOffice Calc and Google Sheets too.

How to use — Why → What → How

Why: Nashik MIS sheets store IFSC codes; Dublin warehouses store brand-prefixed SKUs. You need the prefix in its own column for pivots without retyping hundreds of rows by hand. In banking MIS and warehouse masters, fixed prefixes are daily work. Drill LEFT with TRIM until students stop counting spaces by eye. Then show TEXTBEFORE as the modern upgrade when a dash marks the cut.

What: LEFT returns the first N characters as text. It does not change the original cell. If N is longer than the string, you get the whole string — not an error. Read every argument in the table once before you type; each one changes the answer on purpose.

How — numbered steps:

  1. Click the result cell.
  2. Type =LEFT(
  3. Click the full-code cell (example A2).
  4. Type a comma and the count (example 4).
  5. Close the bracket and press Enter.
  6. Fill the formula down the column.
  7. Spot-check three rows against the original codes.
  8. Remember LEFT returns text — wrap with VALUE only if you must calculate with the result.
  9. Use TRIM first when a CSV paste adds leading spaces.

Ravindra Bagale's Tip

Friends, for fixed-length prefixes (first 4 of IFSC) LEFT beats guessing with FIND. Count once and lock the number.

Ravindra Bagale's Tip

Friends, sleep on LEFT and rebuild example 1 tomorrow without looking. That five-minute test beats rereading the whole page.

Ravindra Bagale's Tip

Friends, after you finish LEFT, open yesterday’s real workbook and find one place this function would have saved ten minutes. That habit turns lessons into salary skills.

Download practice file: practice-left.xlsx (includes sheet About this data, practice sheets, and Answers).

Worked examples

1) Bank code from IFSC

Nashik sheet. First 4 letters.

IFSCBranch
BKID0001234Nashik Main
HDFC0009876Pune Camp
ICIC0005555Nagpur
Formula: =LEFT(A2, 4)

Result: BKID

What it means: Bank code BKID ready for a Pivot.

2) Brand from SKU

Dublin stock list.

SKUPrice (€)
ACE-441212.5
ACE-441914.0
BOL-22019.9
Formula: =LEFT(A2, 3)

Result: ACE

What it means: Brand ACE for filters.

3) Default one character

Grade letter at the start.

Code
A-Maths
B-Science
A-English
Formula: =LEFT(A2)

Result: A

What it means: Omitting num_chars takes 1 character.

4) Phone country hint

Numbers stored as text.

Phone
+919876543210
+447911123456
Formula: =LEFT(A2, 3)

Result: +91

What it means: Country-style prefix for COUNTIFS.

5) Shorter than ask

Tiny label, ask for 10.

Label
OK
YES
Formula: =LEFT(A2, 10)

Result: OK

What it means: Whole short string — no error.

6) With TRIM

Messy paste with spaces.

Raw
BKID0001
BKID0002
Formula: =LEFT(TRIM(A2), 4)

Result: BKID

What it means: TRIM so spaces do not eat your count.

About this data. Small demo rows for learning. Real sheets are longer; the same formula pattern scales when columns are clean.

Common errors and fixes

#VALUE! — num_chars is negative. Fix: Use 0 or a positive whole number.
Wrong prefix — Leading spaces in the cell. Fix: Wrap with TRIM before LEFT.
Looks like a number but is text — You want to add the cut digits. Fix: Wrap LEFT with VALUE.

Notes and tips

  • LEFT always returns text — even when characters are digits.
  • num_chars of 0 returns empty text.
  • Variable-length prefixes before a dash → prefer TEXTBEFORE or LEFT with FIND.
  • LibreOffice Calc supports LEFT the same way.
  • Indian bank files and European product masters both love fixed prefixes. Teach LEFT before FIND so students master the simple case first. Interview follow-ups often ask how to take characters after a dash — that is MID or TEXTBEFORE/TEXTAFTER.
  • LEFT vs TEXTBEFORE: LEFT needs a count; TEXTBEFORE cuts at a delimiter and needs Microsoft 365 or Excel 2021. LEFT vs MID: MID can start at any position.
  • Fictional sample data only — practice amounts and names are made for learning.
  • After the 10 tasks, re-read the errors table once.
  • Say the business question in plain words before you type equals.
  • Keep a scrap sheet for experiments so you do not overwrite class files.
  • Fill formulas down only after the first row looks correct.
  • When two answers look possible, write both on paper then test in Excel.
  • In banking MIS and warehouse masters, fixed prefixes are daily work. Drill LEFT with TRIM until students stop counting spaces by eye. Then show TEXTBEFORE as the modern upgrade when a dash marks the cut.
  • Revisit the LEFT errors table after the quiz — most classroom mistakes are listed there.
  • Build one brand-new example on a blank sheet from memory before you close the laptop.
  • If a result looks wrong, check spaces with LEN and case with exact equals before changing the formula.
  • Share one tip from this page with a classmate in Marathi or Hindi — teaching locks the idea.
  • Keep currency symbols consistent inside a single report column even when practice mixes ₹ $ £ € across examples.
  • When Excel versions differ at home and in class, write the fallback formula under the modern one in a comment cell.
  • Print the revision card for LEFT and stick it near your monitor for one week of real worksheets.
  • When helping a junior, ask them to predict the result before pressing Enter — prediction builds judgement.
  • Keep a personal notebook of the one mistake you make most often with this function; review it monthly.

In real work

Indian bank files and European product masters both love fixed prefixes. Teach LEFT before FIND so students master the simple case first. Interview follow-ups often ask how to take characters after a dash — that is MID or TEXTBEFORE/TEXTAFTER. In banking MIS and warehouse masters, fixed prefixes are daily work. Drill LEFT with TRIM until students stop counting spaces by eye. Then show TEXTBEFORE as the modern upgrade when a dash marks the cut. Classroom drill: write three brand-new LEFT formulas on a blank sheet using names from your own city — if you can invent them without the page open, you own the skill. Then break one formula on purpose (wrong case, wrong start, extra space) and watch the error; recovering from that break is half of interview readiness.

How it compares

LEFT vs TEXTBEFORE: LEFT needs a count; TEXTBEFORE cuts at a delimiter and needs Microsoft 365 or Excel 2021. LEFT vs MID: MID can start at any position.

Interview corner

What does LEFT always return?
Text, even if the characters look like numbers.
What if num_chars is larger than the text?
You get the whole text — not an error.
How do you strip a prefix before a hyphen of unknown length?
TEXTBEFORE, or LEFT with FIND to compute the length.

RIGHT, MID, LEN, TEXTBEFORE, FIND

Practice tasks (10)

  1. Task 1. On Practice, put bank code (first 4 of IFSC) in B2 for BKID0001234.
    Hint: count four characters from the left.
  2. Task 2. Fill the bank-code formula down through row 4.
    Hint: relative A2 is fine.
  3. Task 3. Extract brand ACE from ACE-4412 into C2.
    Hint: three characters.
  4. Task 4. Use default LEFT on A-Maths to get the grade letter.
    Hint: omit the second argument.
  5. Task 5. Return +91 from +919876543210.
    Hint: first three characters include the plus.
  6. Task 6. Show LEFT when you ask for 10 from OK.
    Hint: short text is allowed.
  7. Task 7. TRIM then take first 4 of a messy IFSC paste.
    Hint: nest TRIM inside LEFT.
  8. Task 8. In a note cell, say whether LEFT returns number or text.
    Hint: try adding the result to 1.
  9. Task 9. Helper column: first 2 letters of each Branch name.
    Hint: LEFT on the Branch column.
  10. Task 10. If you have Microsoft 365, compare LEFT with TEXTBEFORE on a dashed SKU.
    Hint: only when TEXTBEFORE exists.

Quick quiz

Q1. LEFT(A2,4) on BKID0001234 returns:
Q2. LEFT always returns:
Q3. Default num_chars is:
Q4. Leading spaces are often fixed with:
Q5. If num_chars is larger than the text:

Answers: Q1=BKID, Q2=Text, Q3=1, Q4=TRIM, Q5=Whole text (check after you try).

Revision card

Standalone card (no tip or photo strip). QR opens this lesson. Download the PNG and revise offline.

Revision card: LEFT
LEFT revision card