Exceljet

Quick, clean, and to the point

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 
  • text - The text to clean.
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...