text

`substitute-basic`

Subject: SUBSTITUTE
Category: value
Formula: =SUBSTITUTE("hello world", "world", "earth")
Canonical: hello earth

Per-engine results

matches canonical diverges no fixture

Engine	Verdict	Value
gsheets	match	hello earth
excel	match	hello earth
lattice	match	hello earth
ironcalc	match	hello earth
hyperformula	match	hello earth
libreoffice	diverge	—
formulas	match	hello earth
pycel	match	hello earth