Home Computer Learn How to use Clean Excel formula for data cleaning excel

Learn How to use Clean Excel formula for data cleaning excel

33 second read
0
0
49
1ST.3 2

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.
Load More Related Articles
Load More By amitgupta
Load More In Computer

Leave a Reply

Check Also

How to Check BUSY Updates

How to Check BUSY Updates Company > Check BUSY Updates Check BUSY Updates option provid…