SUBSTITUTEFIRST

Syntax

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

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

String	Search string	New string	SUBSTITUTEFIRST returns
search	nomatch	replacement	search
search	search	replacement	replacement
search search	search	replacement	replacement search