Excel CLEAN Function

Excel CLEAN Function

Summary

The Excel CLEAN function takes a text string and returns text that has been "cleaned" of line breaks and other non-printable characters.

Purpose

Strip non-printable characters from text

Return value

Text with non-printable characters removed.

Syntax

=CLEAN (text)

Arguments

Usage notes

You can use CLEAN to remove characters that are not printable from text. You can also use CLEAN to strip line breaks from text.

Note: The CLEAN function removes the first 32 (non-printable) characters in the 7-bit ASCII code (values 0 through 31) from text. Unicode contains other non-printable characters that are not removed. Microsoft has an article that provides more detail here: http://office.microsoft.com/en-us/excel-help/remove-spaces-from-the-begi...

 

Excel CLEAN Function

Summary

The Excel CLEAN function takes a text string and returns text that has been "cleaned" of line breaks and other non-printable characters.

Purpose

Strip non-printable characters from text

Return value

Text with non-printable characters removed.

Syntax

=CLEAN (text)

Arguments

Usage notes

You can use CLEAN to remove characters that are not printable from text. You can also use CLEAN to strip line breaks from text.

Note: The CLEAN function removes the first 32 (non-printable) characters in the 7-bit ASCII code (values 0 through 31) from text. Unicode contains other non-printable characters that are not removed. Microsoft has an article that provides more detail here: http://office.microsoft.com/en-us/excel-help/remove-spaces-from-the-begi...