# CLEAN

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content



This function removes all non-printable characters from text.

## Syntax

CLEAN(*text*)

## Arguments

The text argument is any data from which you want to remove non-printable characters.

## Remarks

Use this function to remove text that contains characters that might not print with your operating system. For example, you can use this function to remove some low-level computer code, which is frequently at the beginning and end of data files and cannot be printed

## Data Types

Accepts string data. Returns string data.

## Example

In this example, `CHAR(7)` returns a non-printable character
`CLEAN(CHAR(7)&"text"&CHAR(7))` gives the result `text`

## Version Available

This function is available in product version 1.0 or later.

## See Also

[TRIM](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsTtoZ/FunctionTRIM) \| [SUBSTITUTE](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsRtoS/FunctionSUBSTITUTE) \| [Text Functions](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-functs/formulas-functtypes/formulas-functstext)