## Overview Convert a specified number of characters from the target string into another character. ## Syntax ``` $REPLACE(Target String, Start Position, Number of characters, Replacement String) ``` ## Parameters |Parameter|Type|Required|Description| |:---|:---|:---|:---| |Target String|Arbitrary String|Required|| |Start Position|Half-width numerical value. Integer of 1 or more|Required|Specify the position of the first character to be replaced with the replacement string. The first character is 1. | |Number of characters|Half-width numerical value. Integer of 1 or more|Required|Specify the number of characters to be replaced with the replacement string. | |Replacement String|Arbitrary String|Required|| ### Column Usable as Parameters |Parameter|Classification|Numerical Value|Date|Description|Check| |:---|:---|:---|:---|:---|:---| |Target String|Yes|Yes|Yes|Yes|No| |Start Position|Yes|Yes|No|Yes|No| |Number of characters|Yes|Yes|No|Yes|No| |Replacement String|Yes|Yes|Yes|Yes|No| ## Return Value The string after replacement. ### Return Value for Target Column |Target|Return Value| |:---|:---| |Classification (including title, status, manager, owner)|Display return value. If the return value is a half-width numerical value and is 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 the return value. | |Check (including lock)|Do not display. | ## Usage Example ① Specify parameters by screen item name (name displayed) ### Formula  ### Parameters  ### Calculation Result