Trim() Removes leading and trailing spaces from a string.
Sub strDemo4() Debug.Print Trim(" My String ") End Sub