How do I use CLEAN in Excel?
Use CLEAN when you want to remove non-printable characters. Enter Text in that order, then add optional arguments when needed.
Excel Function
CLEAN
Removes non-printable characters.
CLEAN(text)Arguments
text
RequiredEnter a text value (wrap with quotes when needed).
Practice Preview
Use CLEAN to remove non-printable control characters from cell B2 (Name in column B).
Example Table
| # | AEmployee ID | BName | CEmail | DPayment Amount | EAmount Text |
|---|---|---|---|---|---|
| 2 | E001 | Taro Tanaka | t.tanaka@example.com | 1200 | 1200 |
| 3 | E002 | Hanako Suzuki | h.suzuki@example.com | 980 | 980 |
| 4 | |||||
| 5 | |||||
| 6 | |||||
| 7 | |||||
| 8 |
How to Use (Formula)
=CLEAN(B2)Result
Taro Tanaka
Practice This Function
CLEAN FAQ
Where can I practice CLEAN?
Use the "Start Function Practice" button to jump straight into CLEAN drills.
What arguments does CLEAN use?
The main arguments are Text. Enter them in order.