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	[object Object]
excel	match	[object Object]
lattice	match	hello earth
ironcalc	match	hello earth
hyperformula	match	hello earth
libreoffice	diverge	—
formulas	match	hello earth
pycel	match	hello earth