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...

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.