Mid

This function returns a substring of an existing string. The resulting substring is of length characters long and begins at the Start character number — counting from one, not zero — in the original string expression.

Syntax

Mid(aStringExpression, startNumExpression,[length])

Example

The following code example shows how to set Test5 to “my.”

Test5 = Mid("This is my String", 9, 2)