View source for Manuals/calci/LEFT

=LEFT(Text, Number_chars)=

where, 
*'''Text''' is a text string containing characters to extract,
*'''Number_chars''' represents the number of characters to be extracted.

LEFT() displays the specified number of characters from a text string.

== Description ==

LEFT(Text, Number_chars)

e.g. LEFT("String",2) displays '''St''' as a result.

*LEFT counts 1 byte per character. LEFT works with the languages that use 'Single Byte Character Set' (SBCS).
*'''Text''' can be any string containing characters, numbers, symbols, blankspaces etc.
*If argument '''Text''' is directly entered in the command, it should be enclosed in double quotes (e.g. "Name").
*Argument '''Number_chars''' indicates the number of characters to be displayed from a text string. '''Number_chars''' should be &gt;0.
*If '''Number_chars''' &gt;'length of text', Calci displays the entire text.
*If '''Number_chars''' is omitted, Calci assumes it to be 1.

== Examples ==

Consider the following examples as input to LEFT() function.

<div id="2SpaceContent" class="zcontent" align="left">

{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
| class="sshl_f" |Wel-Come
| class=" " |
| class=" " |

|- class="odd"
| class="sshl_f" |JOHN SMITH
| class=" " |
| class=" " |

|- class="even"
| class="sshl_f" |123*123
| class=" " |
| class=" " |

|- class="odd"
| class="sshl_f" | 
| class=" " |
| class=" " |
|}

 =LEFT(A1,8) : Displays first 8 characters in a string from cell A1. Displays '''Wel-Come''' as the output. 
 =LEFT(A2,5) : Displays first 5 characters in a string from cell A2. Displays '''JOHN ''' as the output. Space Character is also counted.
 =LEFT(A2) : Displays first character '''J''' in a string from cell A2 as the output.
 =LEFT(A3,4) : Displays first 4 characters in a string from cell A3. Displays '''123*''' as the output.
 =LEFT("Good Morning",20) :Displays the full text string '''Good Morning''' as the output.

== See Also ==
{{#ev:youtube|C_qfEZPbPSk|280|center|LEFT}}


== See Also ==

*[[Manuals/calci/LEFTB | LEFTB]]

== References ==

*[http://en.wikipedia.org/wiki/String_(computer_science) String]