Functions
CLEAN
Remove non-printable characters from text
When to use it
When should I use CLEAN?
Use CLEAN when you have imported text from external sources — databases, web scrapes, or legacy files — that may contain non-printable control characters (ASCII 0–31) causing display or parsing issues.
Used in
Syntax
CLEAN(text)