How to Use LEFT, RIGHT, and MID
Last updated: 2026-09-06
⚡ Quick Answer
String extraction functions allow you to parse specific character blocks from alphanumeric codes.
=MID(A2, 3, 4)📊 Visual Demo
HOME · INSERT · FORMULAS · DATA
fx =MID(A2, 3, 4)
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | 1 | US-1092-NY | LEFT(A2, 2) | 2 characters | US |
| 2 | 2 | US-1092-NY | MID(A2, 4, 4) | Start 3, Len 4 | 1092 |
| 3 | 3 | US-1092-NY | RIGHT(A2, 2) | 2 characters | NY |
🧠 Deep Dive
String extraction functions allow you to parse specific character blocks from alphanumeric codes.
Key Insights
- Text functions are position-based (LEFT, RIGHT, MID).
- FIND is case-sensitive, SEARCH is not.
Common Mistakes
- Hard-coding character positions on variable data.
Pro Tips
- Parse once into helper columns.
- Test on longest/shortest strings.
FAQ
What does this formula do in plain English?
String extraction functions allow you to parse specific character blocks from alphanumeric codes.
Why is my formula not working?
Hard-coding character positions on variable data.
Does this work in Google Sheets?
Yes, this syntax is fully compatible with Google Sheets.
What is the most common mistake?
Hard-coding character positions on variable data.
Related Guides
How to Use TEXTJOIN in ExcelHow to Format Text Case in ExcelHow to Use the EXACT FunctionHow to Use SUBSTITUTE and REPLACEExcel Error Hub
Need Complete Playbooks?
Download our verified manuals covering ERP Cleanup and Modeling.
Explore Playbook Series (From ₹199)