Formula (Extended): $TRIM Function
## Overview
Remove unnecessary spaces before and after a string. Spaces within the string are not removed.
## Syntax
```
$TRIM(string)
```
## Parameters
|Parameter|Type|Required|Description|
|:---|:---|:---|:---|
|String|Arbitrary String|Required||
### Column Usable as Parameters
|Parameter|Classification|Numerical Value|Date|Description|Check|
|:---|:---|:---|:---|:---|:---|
|String|Yes|Yes|Yes|Yes|No|
## Return Value
A string with spaces before and after the string removed.
### Return Value for Target Column
|Target|Return Value|
|:---|:---|
|Classification (including title, status, manager, owner)|Display return value. In the case of a drop-down list with values, the options that match the return value are displayed. |
|Numerical Value (including work volume, progression rate, remaining work volume)|Display return value only if the return value is a half-width numerical value. |
|Date (including start and completion)|Display return value only if the return value is in date format. |
|Description (including content)|Display return value. |
|Check (including lock)|Do not display. |
## Usage Example 1
Specify parameters by screen column name (name displayed)
### Formula
![image](https://pleasanter.org/binaries/d4de8a9c6dcf49d78fc61c293b18be0b)
### Parameters
![image](https://pleasanter.org/binaries/e2c190b2c3dd4218b4543792241b9ac3)
### Calculation Result
![image](https://pleasanter.org/binaries/6a4d9461504947a29e3e29cd4ba76e53)