MID
Takes characters from the middle of text.
How it’s written
MID(text, start, count)Example
| A | |
|---|---|
| 1 | Code |
| 2 | NOR-4821-K |
=MID(A2,5,4)Result: 4821
Takes 4 characters, starting at the 5th.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
Spaces and dashes count as characters.
Practice it properly
Pulling text apart gives you real tasks, with your formulas tested on data you haven’t seen.