Excel Practice - MID
Instruction
From text in A3, start at character 9 and return 4 characters.
Formula Syntax
=MID(text, start_num, num_chars)
- text: Input text value.
- start_num: Starting character position (1-based).
- num_chars: Number of characters to extract.
What it does
Extract text from the middle using start and 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
- Use MID with clean and consistent ranges for predictable results.
- Validate data types (number, text, date) before applying the formula.
- Test the formula with a small sample first, then scale it to larger ranges.