Formula (Extended): $LEFT Function
## Overview
Return the specified number of characters from the beginning of a string.
## Syntax
```
$LEFT(String,[Number of characters])
```
## Parameters
|Parameter|Type|Required|Description|
|:---|:---|:---|:---|
|String|Any string|Required||
|[Number of characters]|Half-width numerical value. Integer of 0 or more|Optional|Specify the number of characters to be extracted. If omitted, it is assumed that 1 is specified. If 0 is specified, an empty string is returned. |
### Column Usable as Parameters
|Parameter|Classification|Numerical Value|Date|Description|Check|
|:---|:---|:---|:---|:---|:---|
|String|Yes|Yes|Yes|Yes|No|
|[Number of characters]|Yes|Yes|No|Yes|No|
## Return Value
The extracted string.
If [Number of characters] is greater than the number of characters in the string, the entire string is returned.
### Return Value Display Content
|Target|Display Content of Return Value|
|:---|:---|
|Classification (including title, status, manager, owner)|Display return value. If the return value is a half-width numerical value and a drop-down list with values, display the options that match the return value. |
|Numerical Value (including work volume, progression rate, remaining work volume)|Displays the 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 a string in date format. |
|Description (including content)|Display return value. |
|Check (including lock)|Do not display. |
## Usage Example ①
Specify the parameter by the screen column name (name displayed)
### Formula
![image](https://pleasanter.org/binaries/4309eb7b116a4f84aec64f4a8e86c369)
### Parameters
![image](https://pleasanter.org/binaries/1a3921e2d9ae4b959c171442e7f71d99)
### Calculation Result
![image](https://pleasanter.org/binaries/73be0b3630874c969b8e06eac5e013b8)
## Usage Example ②
Specify the parameter [Number of characters]
### Formula
![image](https://pleasanter.org/binaries/4723ed176fff49dfaa9df3b9c7fc6294)
### Parameters
![image](https://pleasanter.org/binaries/71be8e97ce1c4440bd825783420d3dd6)
### Calculation Result
![image](https://pleasanter.org/binaries/b4e4ae2d52104b1d8ab11b5db3b58b7e)