WorksheetFunction.Trim method (Excel)

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.

Syntax

expression.Trim (Arg1)

expression A variable that represents a WorksheetFunction object.

Parameters

Name Required/Optional Data type Description
Arg1 Required String Text - the text from which you want spaces removed.

Return value

String

Remarks

Important

The TRIM function in Excel 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 webpages as the HTML entity,  . By itself, the Trim function and WorksheetFunction.Trim method don't remove this nonbreaking space character.

The WorksheetFunction.Trim method in Excel differs from the Trim function in VBA, which removes only leading and trailing spaces.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.