Excel Clean Function with Example

May 11, 2015 Excel Formulas No comments

Excel CLEAN Function Removes Non-Printing Characters

What Does It Do?

This function removes any nonprintable characters from text.

These nonprinting characters are often found in data which has been imported

from other systems such as database imports from mainframes.

Syntax

=CLEAN(TextToBeCleaned)

Formatting

No special formatting is needed. The result will show as normal text.

Subscribe to: Post Comments ( Atom )