Difference between revisions of "Manuals/calci/LEFT"
Jump to navigation
Jump to search
| Line 39: | Line 39: | ||
Lets see an example in (Column1, Row2) | Lets see an example in (Column1, Row2) | ||
| − | <nowiki>=LEFT( | + | <nowiki>=LEFT(B1C1,2)</nowiki> |
LEFT returns JO. | LEFT returns JO. | ||
| Line 45: | Line 45: | ||
Lets see an another example in (Column1,Row3) | Lets see an another example in (Column1,Row3) | ||
| − | <nowiki>=LEFT( | + | <nowiki>=LEFT(B1C1)</nowiki> |
LEFT returns J(if omitted,considered as 1). | LEFT returns J(if omitted,considered as 1). | ||
| Line 51: | Line 51: | ||
Consider an example in (Column1, Row4) | Consider an example in (Column1, Row4) | ||
| − | <nowiki>=LEFT( | + | <nowiki>=LEFT(B1C1,20)</nowiki> |
LEFT returns JOHN SMITH(Number_chars> length of text). | LEFT returns JOHN SMITH(Number_chars> length of text). | ||
| Line 111: | Line 111: | ||
| class=" " | | | class=" " | | ||
| class=" " | | | class=" " | | ||
| + | |} | ||
Revision as of 09:20, 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 |
