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.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for