.

CLEAN EXCEL FORMULA

EXCEL FORMULA
Function Dictionary Function Examples Function Categories

CLEAN

           
 
Dirty Text Clean Text
Hello Hello  =CLEAN(C4)
He llo Hello  =CLEAN(C5)
Hello Hello  =CLEAN(C6)
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.

.

Popular posts from this blog

Tamilnadu SIXTH all books free download, Tamilnadu 6th all books free download

Tamilnadu FIRST STANDARD all books free download, Tamilnadu 1ST STANDARD all books free download