Excel Formulas – Clean Function Removes Nonprintable Char

Clean Function

Text Formulas – Clean Function

[ResponsiveRect]

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.

GenronTech Header-Cartoon

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

Leave a Comment