Difference between revisions of "Manuals/calci/LEFT"
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." | + | <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 |