How to remove non printable characters in excel
CLEAN
What Does It Do?
This function removes any non printable characters from text.
These non printing 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