Loading…
Loading…
TRIM removes leading and trailing spaces and squeezes repeated spaces between words into one. CLEAN strips non-printable characters that come from other systems.
Syntax
TRIM(text) · CLEAN(text)
Read the lesson, then try it yourself in a live spreadsheet.