Learn Excel - Simplify Life with Excel Concepts

Excel CLEAN Function

CLEAN Function Example

How to use the CLEAN Function

This Excel tutorial explains how to use the Excel CLEAN function with syntax and examples.

SUMMARY:

The Excel CLEAN function use to removes all nonprintable characters from a text or text string, It removed the nonprintable text or any line break from the beginning or end of the input text string.

For example,

  • The formula =CLEAN(" Hi Jack") would return "Hi Jack"
  • The formula =CLEAN("Hi Tim"& CHAR(10)) would return "Hi Tim"

PURPOSE:

To removes all nonprintable characters.

RETURN VALUE:

The CLEAN function returns text String.

SYNTAX:

=CLEAN(text)

ARGUMENTS:

The CLEAN function syntax has the following arguments:

  • text: Required. Any text or text string from which you want to remove non-printable characters.

REMARKS:

  • It remove all non-printable character from beginning, end or in between the text string.

Useful Links: Link 1Link 2Link 3Link 4