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.
This will be useful when u Convert a PDF to word and you get some non printable characters
Syntax:
=CLEAN(TextToBeCleaned)
Example:
These nonprinting characters are often found in data which has been imported from other systems such as database imports from mainframes.
This will be useful when u Convert a PDF to word and you get some non printable characters
Syntax:
=CLEAN(TextToBeCleaned)
Example:
No comments:
Post a Comment