VBA/Excel/Access/Word/String Functions/Trim

Trim() Removes leading and trailing spaces from a string.

 
Sub strDemo4()
   Debug.Print Trim("  My String ")
End Sub