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

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

   <source lang="vb">

Sub strDemo4()

  Debug.Print Trim("  My String ")

End Sub

</source>