Clean

We use clean function in excel to remove nonprintable characters from a cell.

 

Clean Function का प्रयोग हम excel में NonPrintable characters को हटाने के लिए करते हैं.

 

Syntax

=CLEAN(TextToBeCleaned)

=CLEAN(C4)

 

 

 

 

CLEAN removes characters generated by 36 ASCII codes which is below.

 

 

 

 

 

 

Click Here For Download Excel File

 

 

 

Function

Text Function