> For the complete documentation index, see [llms.txt](https://docs.nedyx.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/text-functions/substitute.md).

# SUBSTITUTE

#### Syntax <a href="#syntax.53" id="syntax.53"></a>

**SUBSTITUTE**(*text*; *oldText*; *newText; option*)

* *text* - the text in which to search for oldText - ***Value type**: text*
* *oldText* - the text which is to be found in parameter text - ***Value type**: text*
* *newText* - the text with which *oldText* should be replaced- ***Value type**: text*
* *option* - defines if the substitution should be done with a regular expression - ***Value type**: constant (optional, default: empty - i.e. plain text replacement)*

  Possible values are

  * *regex* - the replacement should be done using a regular expression for parameter *oldText*

#### Remarks <a href="#remarks.40" id="remarks.40"></a>

* The *text* parameter can also be a range with several texts. The SUBSTITUTE function is then applied to all these texts.
* For the parameters *oldText* and *newText*, column ranges can be specified. The text replacement then takes place one after the other (from top to bottom) for all text pairs of these two parameters.
* The search is performed case-sensitive, so the found text within parameter *text* must have the same casing than the parameter *oldText*.

#### Examples <a href="#examples.17" id="examples.17"></a>

<figure><img src="/files/v2MMsxZ41mwMbRyA5zhd" alt=""><figcaption></figcaption></figure>

<figure><img src="/files/fN8UWHe6J9DY1MxmMo7O" alt=""><figcaption></figcaption></figure>

<figure><img src="/files/41a16HmFT4s3W2KfjoTV" alt=""><figcaption></figcaption></figure>

<figure><img src="/files/PXIQ91it4jEHX2JkCFTa" alt=""><figcaption></figcaption></figure>

<figure><img src="/files/Xt8kfrzkgulAs3cD94il" alt=""><figcaption></figcaption></figure>