Manuals/calci/LEFT - Revision history

Swapna: /* See Also */

2015-04-15T20:19:55Z

Swapna at 20:11, 15 April 2015

2015-04-15T20:11:14Z

Swapna at 23:05, 30 January 2014

2014-01-30T23:05:35Z

Swapna at 21:56, 27 January 2014

2014-01-27T21:56:02Z

Swapna at 21:51, 27 January 2014

2014-01-27T21:51:41Z

Swapna at 21:48, 27 January 2014

2014-01-27T21:48:32Z

Swapna at 21:40, 27 January 2014

2014-01-27T21:40:08Z

Jayaram at 15:22, 18 November 2013

2013-11-18T15:22:52Z

Jayaram at 15:20, 18 November 2013

2013-11-18T15:20:55Z

Jayaram at 15:18, 18 November 2013

2013-11-18T15:18:55Z

@@ Line 54: / Line 54: @@
   =LEFT("Good Morning",20) :Displays the full text string '''Good Morning''' as the output.
-== See Also ==
+== Related Videos ==
 {{#ev:youtube|C_qfEZPbPSk|280|center|LEFT}}
 == See Also ==

@@ Line 53: / Line 53: @@
   =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 ==

@@ Line 13: / Line 13: @@
 e.g. LEFT("String",2) displays '''St''' as a result.
-*LEFT counts 1 byte per characters. LEFT works with the languages that use 'Single Byte Character Set' (SBCS).
+*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").

@@ Line 9: / Line 9: @@
 == Description ==
-LEFT(txt)
+LEFT(Text, Number_chars)
 e.g. LEFT("String",2) displays '''St''' as a result.

@@ Line 50: / Line 50: @@
   =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(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.

@@ Line 2: / Line 2: @@
 where,
-*<math>Text</math> is a text string containing characters to extract,
+*'''Text''' is a text string containing characters to extract,
-*<math>Number_chars</math> represents the number of characters to be extracted.
+*'''Number_chars''' represents the number of characters to be extracted.
 LEFT() displays the specified number of characters from a text string.
@@ Line 14: / Line 14: @@
 *LEFT counts 1 byte per characters. LEFT works with the languages that use 'Single Byte Character Set' (SBCS).
-*<math>Text</math> can be any string containing characters, numbers, symbols, blankspaces etc.
+*'''Text''' can be any string containing characters, numbers, symbols, blankspaces etc.
-*If argument <math>Text</math> is directly entered in the command, it should be enclosed in double quotes (e.g. "Name").
+*If argument '''Text''' is directly entered in the command, it should be enclosed in double quotes (e.g. "Name").
-*Argument <math>Number_chars</math> indicates the number of characters to be displayed from a text string. <math>Number_chars</math> should be &gt;0.
+*Argument '''Number_chars''' indicates the number of characters to be displayed from a text string. '''Number_chars''' should be &gt;0.
-*If <math>Number_chars</math> &gt;'length of text', Calci displays the entire text.
+*If '''Number_chars''' &gt;'length of text', Calci displays the entire text.
-*If <math>Number_chars</math> is omitted, Calci assumes it to be 1.
+*If '''Number_chars''' is omitted, Calci assumes it to be 1.
 == Examples ==

@@ Line 1: / Line 1: @@
-<div id="6SpaceContent" class="zcontent" align="left">
+=LEFT(Text, Number_chars)=
-==Description==
+where,
-'''LEFT'''(Text, Number_chars)
+LEFT() displays the specified number of characters from a text string.
-where,
+== Description ==
-'''Text''' - is the text string to extract.
+LEFT(txt)
-'''Number_chars''' - represents the number of charcaters you want LEFT to extract.
+e.g. LEFT("String",2) displays '''St''' as a result.
-</div>
+*LEFT counts 1 byte per characters. LEFT works with the languages that use 'Single Byte Character Set' (SBCS).
-----
+*<math>Text</math> can be any string containing characters, numbers, symbols, blankspaces etc.
-<div id="1SpaceContent" class="zcontent" align="left">
+*If argument <math>Text</math> is directly entered in the command, it should be enclosed in double quotes (e.g. "Name").
-LEFT retuns the charcater from text string, based on number of characters.
+== Examples ==
-</div>
+Consider the following examples as input to LEFT() function.
 <div id="2SpaceContent" class="zcontent" align="left">
 {| id="TABLE3" class="SpreadSheet blue"
 |- class="even"
-| class=" " |
+| class="sshl_f" |Wel-Come
 | class=" " |
 | class=" " |
 |- class="odd"
-| Row3
+| class="sshl_f" |JOHN SMITH
 | class=" " |
 | class=" " |
 |- class="even"
-| Row4
+| class="sshl_f" |123*123
 | class=" " |
 | class=" " |
 |- class="odd"
-| class=" " | Row5
+| class="sshl_f" |
 | class=" " |
 | class=" " |
 |}

@@ Line 101: / Line 101: @@
 | class=" " | Row5
 | 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=" " |

@@ Line 39: / Line 39: @@
 Lets see an example in (Column1, Row2)
-<nowiki>=LEFT(R1C1,2)</nowiki>
+<nowiki>=LEFT(B1C1,2)</nowiki>
 LEFT returns JO.
@@ Line 45: / Line 45: @@
 Lets see an another example in (Column1,Row3)
-<nowiki>=LEFT(R1C1)</nowiki>
+<nowiki>=LEFT(B1C1)</nowiki>
 LEFT returns J(if omitted,considered as 1).
@@ Line 51: / Line 51: @@
 Consider an example in (Column1, Row4)
-<nowiki>=LEFT(R1C1,20)</nowiki>
+<nowiki>=LEFT(B1C1,20)</nowiki>
 LEFT returns JOHN SMITH(Number_chars&gt; length of text).
@@ Line 111: / Line 111: @@
 | class=" " |
 | class=" " |

← Older revision		Revision as of 15:18, 18 November 2013
Line 111:		Line 111:
	\| class=" " \|		\| class=" " \|
	\| class=" " \|		\| class=" " \|
−	\|}