How to Use the Clean Function in Excel for Multiple Cells
|
|
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.
|
|
||||||
|
|
|
|
|
|
|
|
|
No comments:
Post a Comment