{"id":1165,"date":"2018-07-01T15:06:41","date_gmt":"2018-07-01T15:06:41","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1165"},"modified":"2023-11-02T18:47:46","modified_gmt":"2023-11-02T18:47:46","slug":"clean","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/clean\/","title":{"rendered":"CLEAN function"},"content":{"rendered":"\n
The CLEAN function in Excel is a simple but useful text function that removes non-printable characters from a text string. These non-printable characters can often be hidden and cause issues when working with data, so CLEAN helps clean up your data.<\/p>\n\n\n\n
CLEAN(text)<\/strong><\/p>\n\n\n\n The CLEAN function is straightforward to use. You provide a text string as an argument, and it returns a new text string with non-printable characters removed. Here’s a simple example:<\/p>\n\n\n\n This formula will remove the non-printable character (represented by \u0003) from the text and return “Hello, World!”<\/p>\n\n\n\n You can use the CLEAN function to clean up text from various sources, such as imported data, web scraping, or data entry, where non-printable characters may be present. It ensures your data is in a clean, readable format for further analysis or presentation.<\/p>\n\n\n\n It’s essential to remember that the CLEAN function is not designed to handle all text-cleaning scenarios, but it is a useful tool for dealing with non-printable characters.<\/p>\n","protected":false},"excerpt":{"rendered":" The CLEAN function in Excel is a simple but useful text function that removes non-printable characters from a text string. These non-printable characters…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"\nArguments<\/h2>\n\n\n\n
text<\/b><\/td> The text from which you want to remove non-printable characters. This is the only required argument.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n How to use<\/h2>\n\n\n\n
=CLEAN(\"Hello, World!\u0003\")<\/code><\/pre>\n\n\n\n