IntermediateText Functions
Pull the year out of an order code with MID
Extract characters from the middle of a text value.
MID
7 min25 points
MID
Returns characters from the middle of a text value, given a start point.
Syntax
MID(text, start_num, num_chars)
Text Functions.
A worked example
=MID(A2,5,4)
Returns 2026
Takes four characters starting at position 5 — the year inside ORD-2026-1041.
Where it goes wrong
Counting from zero. MID starts at 1, and it counts separators too, so the hyphen occupies a position.
Practise MID
Knowing what a function does and being able to write it from memory are different skills. These close the gap.