Search

Learn How to use Clean Excel formula for data cleaning excel

CLEAN

clean data in excel
What Does It Do?This function removes any non-printable 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.
Share this article :
Facebook
Twitter
LinkedIn

Leave a Reply