Skip to Content

CLEAN

Removes all nonprintable characters from text

Syntax

CLEAN(text)

Parameters

  • text: Required. Any worksheet information from which you want to remove nonprintable characters

Example

=CLEAN(A1)
Returns: StringSince: Excel 2003