TRIM

Name

Trim

Description

Removes extra spaces from a string and leaves single spaces between words.

Syntax

TRIM(text)

Remarks

The text argument specifies the string containing the spaces you want to remove.

Data Type

Accepts string data. Returns string data. For more information, see Data Type for Each Cell Type.

Example

fpSpread1.Formula = "TRIM("" First Quarter"")" equals "First Quarter"