Use Of Clean
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.
| ||||||||
कोई टिप्पणी नहीं:
एक टिप्पणी भेजें