regex

`replace-swap-first-and-last-name`

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	—
formulas	diverge	$2, $1
pycel	diverge	#NAME?