SUBSTITUTEFIRST

Owned by Juliane Wetzel
Last updated: May 10, 2023 by Konsta Danyliuk (Deactivated)

Syntax

SUBSTITUTEFIRST(<string>; <search string>; <new string>)

Description

Substitutes new text for the first occurrence of the old text in a text string.

Examples

StringSearch stringNew stringSUBSTITUTEFIRST returns
searchnomatchreplacementsearch
searchsearchreplacementreplacement
search searchsearchreplacementreplacement search