youtube SEO, tricks for blogger, wordpress tricks for earning money online youtube earning, whatsapp,windows, android & all about new technology.

Excel Clean Function with Example

No comments

Excel CLEAN Function Removes Non-Printing Characters

What Does It Do?

  • 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.

  • Syntax

  • =CLEAN(TextToBeCleaned)


  • No special formatting is needed. The result will show as normal text.