trim in vba code example
Example: vba trim
Dim s As String
s = " abc "
Debug.Print "|" & LTrim(s) & "|" ' |abc |
Debug.Print "|" & RTrim(s) & "|" ' | abc|
Debug.Print "|" & Trim(s) & "|" ' |abc|
Dim s As String
s = " abc "
Debug.Print "|" & LTrim(s) & "|" ' |abc |
Debug.Print "|" & RTrim(s) & "|" ' | abc|
Debug.Print "|" & Trim(s) & "|" ' |abc|