Using LTrim, RTrim, and Trim to Trim Spaces from a String

 
Sub TrimDemo()
    Dim strUntrimmed As String, strTrimmed As String
    strUntrimmed = Selection.Text
    strTrimmed = Trim(strUntrimmed)
End Sub

1.	Format() Formats strings, dates, and numbers as specified.
2.	InStrRev begins searching at the end of a string and returns the position where one string is found within another string:
3.	Instr function returns the position where one string begins within another string
4.	Left(string, length) returns the specified number of characters from the left end of a string
5.	Right(string, length) returns a specified number of characters from the right end of a string
6.	Mid(string, start[, length]) returns the specified number of characters from inside the given string
7.	UCase returns a string that is all uppercase
8.	InStr() Returns the location of the first character of a substring within another string.
9.	InStr(): A number representing the place value of a particular character within a string
10.	Len() Returns the number of characters in a string.
11.	Len() return the number of characters in a string
12.	LCase() Converts the string to lowercase.
13.	UCase() Converts the string to uppercase.
14.	StrReverse() Reverses the order of the characters in a string.

Using LTrim, RTrim, and Trim to Trim Spaces from a String : String Function « Data Type « VBA / Excel / Access / Word