vba remove spaces from string code example

Example: vba remove spaces

Dim s As String
s = "  abc  "
Debug.Print "|" & LTrim(s) & "|"         ' |abc  |
Debug.Print "|" & RTrim(s) & "|"         ' |  abc|
Debug.Print "|" & Trim(s) & "|"          ' |abc|