VBA Function: Trim

Description

The VBA TRIM Function returns a string after removing spaces from the left and right of the string.

TRIM Syntax

Trim(text)

VBA Trim Example

Remove extraneous spaces from the beginning and end of the string:

Sub TrimExample1()

     MsgBox Trim("test")              'Returns: "test"
     MsgBox Trim("   test")           'Returns: "test"
     MsgBox Trim("test   ")           'Returns: "test"
     MsgBox Trim("   test   ")        'Returns: "test"
     MsgBox Trim("   test   test   ") 'Returns: "test   test"
     MsgBox Trim("   ")               'Returns: ""
    
End Sub

VBA Trim Example to eliminate extra spaces inside a text

Remove extraneous spaces from the inside of the string:

Sub TrimExample2()

     MsgBox WorksheetFunction.TRIM("   test     test   ") 'Returns: "test test"
    
End Sub