Tutorial by Examples | RIP Tutorial

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

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

VBA • Substrings

Use Right or Right$ to get the 3 right-most characters in a string

Const baseString As String = "Foo Bar" Dim rightText As String rightText = Right$(baseString, 3) 'rightText = "Bar"

VBA • Substrings

Use Mid or Mid$ to get specific characters from within a string

Const baseString As String = "Foo Bar" 'Get the string starting at character 2 and ending at character 6 Dim midText As String midText = Mid$(baseString, 2, 5) 'midText = "oo Ba"

VBA • Substrings

Use Trim to get a copy of the string without any leading or trailing spaces

'Trim the leading and trailing spaces in a string Const paddedText As String = " Foo Bar " Dim trimmedText As String trimmedText = Trim$(paddedText) 'trimmedText = "Foo Bar"

VBA • Substrings