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.
Parameters
- text
- The text string containing the characters you want to extract.
- position
- 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.
- number
- Specifies the number of characters you want to return from the text.
Returns
Text
Examples
Mid("type20A", 5, 2)
returns the text value "20".Mid("type20A", 7, 3)
returns the text value "A".