How to Trim Excel With VBA
- 1). Click the "Developer" tab in Excel, and click "Visual Basic."
- 2). Click the name of the VBA file in the left hand window where you want to insert the trim function.
- 3). Cut and paste the following lines of code into the VBA code:
"Dim LResult As String
LResult = Trim (" text ")". - 4). Replace "text" in the code with the actual text you want to trim. In the above example, the blank spaces would be removed from the statement, passing "text" to the variable LResult.