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