What is the syntax to return a substring?

To return a substring that does not start with the beginning of the string: click me
To return a substring that starts with the beginning of the string: click me
To return a substring that does not start with the beginning of the string: click me

Advertisements

What is the syntax to split a string from the middle?

Mid (String, start, length)
'String - string from which return value is extracted; mandatory parameter
'start - integer of starting position of extraction; mandatory parameter
'length - length of extraction; optional
'examples
Dim sentence As String
sentence = "blackgraywhite"
MsgBox (Mid(sentence, 6, 4)) 'gray
MsgBox (Mid(sentence, 1, 5)) 'black
MsgBox (Mid(sentence, 10)) 'white