SUBSTITUTEALL

Syntax

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

Substitutes new text for all occurrences of old text in a text string.

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