Skip to main content
Version: Streamsheets 2.4

SUBSTITUTE

Substitutes a text string with a new text.

Syntax

=SUBSTITUTE(Text, OldText, NewText[, Occurrence])

Arguments

NameDescription
TextText for which to substitute characters.
OldTextThe text to be replaced.
NewTextThe text which will replace specified OldText.
OccurrenceOptional. Specifies which occurrence of OldText to be replaced by NewText. If not specified every occurrence of OldText will be replaced.

Return Value

A string value with replaced text.

Example

FunctionResult
=SUBSTITUTE("Replace me now", "now", "later")"Replace me later"