vba excel substring code example

Example: vba substring

Debug.Print Left("abcdef", 3)       ' abc
Debug.Print Right("abcdef", 2)      ' ef
Debug.Print Mid("abcdef", 2, 3)     ' bcd
Debug.Print InStr("abcdef", "de")   ' 4
Debug.Print Len("abcdef")           ' 6