Syntax
Mid(String, StartingPosition [, NumberOfCharacters])Examples
=Mid("INV-2026-0042", 5, 4)"2026"
Maker notes
- Positions start at 1, not 0.
Mid
Returns characters from the middle of a string, starting at a position.
Returns characters from the middle of a string, starting at a position.
Mid(String, StartingPosition [, NumberOfCharacters])=Mid("INV-2026-0042", 5, 4)"2026"