CLEAN Function (Functions in Excel)
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. |
0 comments:
Post a Comment