CLEAN

Formulas / CLEAN
Remove non-printable characters from text.
=CLEAN(text)
  • text - required argument that accepts any worksheet information

Examples

  • =CLEAN(A1)

    To clean the text in cell A1, the example formula above can be used. This will remove any non-printable characters and line breaks from the text in A1.


Summary

The CLEAN function removes non-printable characters from text strings in Sourcetable. It was introduced to Sourcetable to help clean data that had been imported from other applications.

  • The CLEAN function strips out non-printable characters from text, but does not remove extra white space characters.
  • However, line breaks may be removed if they are present.

Frequently Asked Questions

What is the CLEAN function?
The CLEAN function is a function in Sourcetable that removes nonprintable characters from text. It removes the first 32 nonprinting characters in the 7-bit ASCII code.
Does the CLEAN function remove Unicode nonprinting characters?
No. The CLEAN function only removes ASCII nonprinting characters.
What information can the CLEAN function accept?
The CLEAN function will accept any Sourcetable worksheet information.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV