Text Formulas – Clean Function

What Does It Do – Clean Function?
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)

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

Advanced Excel Formulas Index

1. Jump To Advance Excel Formulas Main Menu
2. Jump To Database Function
3. Jump To Date and Time Function
4. Jump To Financial Function
5. Jump To Informational Function
6. Jump to Logical Function
7. Jump To Math Function
8. Jump to Statistical Function
9. Jump To Engineering Function
10. Jump To Text Function