Microsoft Excel - Easily Remove Unprintable Characters From Entries (97/2000/2002/v. X/2003)
We recently told you about the TRIM function, which removes extra spaces from a text string. Unnecessary spaces are a problem you often run into when importing data. Another common occurrence that plagues imported data is the presence of unprintable characters. For instance, text might contain control characters that indicate carriage returns or line feeds. When viewed onscreen, they often appear as small squares within cell entries. You can easily remove such characters using the CLEAN function.