CLEAN Function or CLEAN Formula in Excel with step by step example

CLEAN Function or CLEAN Formula in Excel with step by step example

CLEAN

Function removes all non-printable characters from a text or string. Clean function is very useful when you deal with scrapped data coming from various sources having non formatting and special characters in.

Syntax

=CLEAN(text)

  • text: a mandatory parameter, refers to input string which needs to be cleaned.

Formula

Below input string contains ALT + Enter (soft enter) which is a non-printable character cause text align to next line:

Output

Next >> Average, AverageA, AverageIF and AverageIFs Function in Excel

Leave a Reply

Your email address will not be published.