assay
regex

f86e47

Subject
REGEXREPLACE
Category
value
Formula
=REGEXREPLACE("Hello WORLD hello", "(?i)hello", "hi")
Canonical
hi WORLD hi

Per-engine results

matches canonical diverges no fixture

Engine Verdict Value
gsheets match hi WORLD hi
excel match hi WORLD hi
lattice match hi WORLD hi
ironcalc diverge #NAME?
hyperformula diverge #NAME?
libreoffice diverge #NAME?
formulas match hi WORLD hi
pycel diverge #NAME?