Clean Formula
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.
Click on image to enlarge.....
|
|
|
|
|
|
|
|
|
Dirty Text
|
Clean Text
|
|
|
|
|
|
Hello
|
Hello
|
=CLEAN(C4)
|
|
|
|
|
Hello
|
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.
|
|||||