Manuals/calci/CLEAN
CLEAN(Text)
where,
Text - is any text from which to remove nonprintable characters.
It removes all nonprintable characters from text.
CLEAN function remove the first 32 nonprinting characters in the 7-bit ASCII(0 to 31)from text.
CLEAN
Lets see an example in (Column1, Row2)
=CLEAN(R1C1)
CLEAN returns Zcubes.
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | �Zcubes� | |||
| Row2 | Zcubes | |||
| Row3 | ||||
| Row4 | ||||
| Row5 | ||||
| Row6 |
