Manuals/calci/TRIM

Revision as of 20:46, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''TRIM'''(Value) where, '''Value''' - is the text from which you removed spaces. </div> ---- <div id="1S...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

TRIM(Value)

where,

Value - is the text from which you removed spaces.


Calci removes all space from text.


TRIM does not remove space between two words.

TRIM


Lets see an example in (Column1, Row1)

=TRIM("  Zcubes")

TRIM removes the leading space from Zcubes.


Syntax

Remarks

Examples

Description

Column1 Column2 Column3 Column4
Row1 Zcubes
Row2
Row3
Row4
Row5
Row6