Mid(Text text, Numeric position, Numeric number)
Returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify.
- The text string containing the characters you want to extract.
- The position of the first character you want to extract in the text. The first character in the text is at position 1, and so on.
- Specifies the number of characters you want to return from the text.
Mid("type20A", 5, 2)returns the text value "20".
Mid("type20A", 7, 3)returns the text value "A".