Mid

Use the Mid function to return a specified number of characters from as string.

Syntax

Mid(string, start[, length])

Argument Description
string String expression from which characters are returned. If string contains Null, then Null is returned.
start Character position in string at which the part to be taken begins. If start is greater than the number of characters in string, then Mid returns a zero-length string ("").
length Number of characters to return. If omitted, or total number of characters are fewer than length, then all characters from the start to the end position are returned.

To determine the number of characters in a string, use the Len function.

Examples

  • Dim MyVar 
    MyVar = Mid("VB Script is fun!", 4, 6) 
    

    This example returns a string that is six characters long and starts with the fourth character in the string: MyVar = "Script"

  • Mid("This is the middle of this sentence",9,10)

    This example returns "the middle":