Home › Functions › Text › CLEAN
fx
CLEAN
Text  ·  Since: Excel 2003  ·  9 languages

Removes all nonprintable characters from text. Use CLEAN on text imported from other applications that contains characters that may not print with your operating system. For example, you can use CLEAN to remove some low-level computer code that is frequently at the beginning and end of data files and cannot be printed.

🌐 Translations

English CLEAN
Deutsch SÄUBERN
Français EPURAGE
Español LIMPIAR
Italiano LIBERA
Português TIRAR
Nederlands WISSEN.CONTROL
Polski OCZYŚĆ
Русский ПЕЧСИМВ

📦 Availability

Excel versionAvailable
Excel 2007 ✓
Excel 2013 ✓
Excel 2019 ✓
Excel 2021 ✓
Microsoft 365 ✓
Translate a formula with this function
fx EN
fx DE

⌨ Syntax

CLEAN(text)

Arguments

text (required) — Any worksheet information from which you want to remove nonprintable characters.

▶ Examples

=CLEAN(A2)

Related functions

Copied to clipboard