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


  • =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.


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.

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.