VBA SUBSTRING / MID

Use MID function to return a substring:

Function specification:
Mid( string, start, length)

Dim TestString As String = “Mid Function Demo”
‘ Returns “Mid”.
Dim FirstWord As String = Mid(TestString, 1, 3)
‘ Returns “Demo”.