VBA - Trim
Advertisements
The Trim function removes both the leading and the trailing blank spaces of the given input string.
Syntax
Trim(String)
Example
Add a button and add the following function.
Private Sub Constant_demo_Click() var = "Microsoft VBScript" var = " Microsoft VBScript " msgbox ("After Trim : " & Trim(var)) End Sub
When you execute the above function, it produces the following output.
After trim : Microsoft VBScript
vba_strings.htm
Advertisements