Functions
MID
Substring from middle of text
Try it
When to use it
When should I use MID instead of LEFT or RIGHT?
Use MID when the characters you want start somewhere in the middle of the text rather than at the very start or end.
How do I pull a slice between two known positions?
Give MID the start position and how many characters to take. Combine it with FIND when the positions depend on a separator instead of being fixed.
Use cases
Extract the month digits from a date string
Read a batch number out of a serial
Used in
Syntax
MID(text, start, num_chars)