81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199

Better Sheets
Create Free accountMember Login

CLEAN()

Description

Returns the text with the non-printable ASCII characters removed.

How To Use in Sheets

CLEAN(text)

External Links

Clean and trim odd text in Google Sheets

Google Docs Help

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.