CLEAN
Removes all nonprintable characters from text.
TextBeginner EssentialsMost UsedText Cleaning
What it does
Removes non-printable characters from text.
Syntax
CLEAN(text)
Arguments
text(text) — Text to clean.
Examples
Remove line breaks
Clean text that contains a line break.
FORMULA
=CLEAN(A2)
RESULT
HelloWorld
SAMPLE DATA
| A | |
|---|---|
| 1 | Text |
| 2 | Hello World |
| 3 | No issues |