VBA Substrings Use Left or Left$ to get the 3 left-most characters in a string


Example

Const baseString As String = "Foo Bar"

Dim leftText As String
leftText = Left$(baseString, 3)
'leftText = "Foo"