Manuals/calci/CLEAN

From ZCubes Wiki
Revision as of 21:31, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''CLEAN'''(Text) where, '''Text''' - is any text from which to remove nonprintable characters. </div> --...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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
Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/CLEAN&oldid=310"