WorksheetFunction.Trim Method
Removes all spaces from text except for single spaces between words. Use TRIM on text that you have received from another application that may have irregular spacing.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Function Trim ( _
Arg1 As String _
) As String
'Usage
Dim instance As WorksheetFunction
Dim Arg1 As String
Dim returnValue As String
returnValue = instance.Trim(Arg1)
string Trim(
string Arg1
)
Parameters
Arg1
Type: System.StringText - the text from which you want spaces removed.
Return Value
Type: System.String
Remarks
Important
The Trim function was designed to trim the 7-bit ASCII space character (value 32) from text. In the Unicode character set, there is an additional space character called the nonbreaking space character that has a decimal value of 160. This character is commonly used in Web pages as the HTML entity, . By itself, the Trim function does not remove this nonbreaking space character.