assay
text-longtail

clean-strips-newline

Subject
CLEAN
Category
value
Formula
=CLEAN("line1" & CHAR(10) & "line2")
Canonical
line1line2

Owning divergences (1)

Per-engine results

matches canonical diverges no fixture

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