Difference between revisions of "Manuals/calci/TRIM"
Jump to navigation
Jump to search
(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...") |
(No difference)
|
Revision as of 21:46, 24 October 2013
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 |