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