regex

`8d0a25`

Subject: REGEXREPLACE
Category: value
Formula: =REGEXREPLACE("John Smith", "(\w+) (\w+)", "$2, $1")
Canonical: Smith, John

Per-engine results

matches canonical diverges no fixture

Engine	Verdict	Value
gsheets	match	Smith, John
excel	match	Smith, John
lattice	match	Smith, John
ironcalc	diverge	#NAME?
hyperformula	diverge	#NAME?
libreoffice	diverge	#NAME?
formulas	diverge	$2, $1
pycel	diverge	#NAME?