Title: MS Excel: How to use the TRIM Function (WS, VBA)
Headings: MS Excel:
How to use the TRIM Function (WS, VBA)

MS Excel: How to use the TRIM Function (WS, VBA)
Description
Syntax
Parameters or Arguments
text
Returns
Applies To
Type of Function
Example (as Worksheet Function)
Clean Up Spacing Between Words
Example (as VBA Function)

Content: MS Excel: How to use the TRIM Function (WS, VBA)
MS Excel: How to use the TRIM Function (WS, VBA)
This Excel tutorial explains how to use the Excel TRIM function with syntax and examples. Description
The Microsoft Excel TRIM function returns a text value with the leading and trailing spaces removed. You can also use the TRIM function to remove unnecessary spaces between words in a string. The TRIM function is a built-in function in Excel that is categorized as a String/Text Function. It can be used as a worksheet function (WS) and a VBA function (VBA) in Excel. As a worksheet function, the TRIM function can be entered as part of a formula in a cell of a worksheet. As a VBA function, you can use this function in macro code that is entered through the Microsoft Visual Basic Editor. Syntax
The syntax for the TRIM function in Microsoft Excel is: