Difference between revisions of "Manuals/calci/LEFT"

From ZCubes Wiki
Jump to navigation Jump to search
Line 101: Line 101:
 
| class=" " | Row5
 
| class=" " | Row5
 
| class="  SelectTD ChangeBGColor SelectTD" |
 
| class="  SelectTD ChangeBGColor SelectTD" |
<div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]]  </div>
+
<div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">
 
| class=" " |
 
| class=" " |
 
| class=" " |
 
| class=" " |

Revision as of 10:22, 18 November 2013

Description

LEFT(Text, Number_chars)

where,

Text - is the text string to extract.

Number_chars - represents the number of charcaters you want LEFT to extract.


LEFT retuns the charcater from text string, based on number of characters.


If Number_chars <= 0,LEFT returns #ERROR.

If Number_chars > length of text, it returns all of text.

If Number_chars is omitted, it is considered as 1.


LEFT


Lets see an example in (Column1, Row2)

=LEFT(B1C1,2)

LEFT returns JO.

Lets see an another example in (Column1,Row3)

=LEFT(B1C1)

LEFT returns J(if omitted,considered as 1).

Consider an example in (Column1, Row4)

=LEFT(B1C1,20)

LEFT returns JOHN SMITH(Number_chars> length of text).


Syntax

Remarks

Examples

Description

Column1 Column2 Column3 Column4
Row1 JOHN SMITH
Row2 JO
Row3 J
Row4 JOHN SMITH
Row5
Row6