Administrators, writer
3,314
edits
Changes
Jump to navigation
Jump to search
Line 39:
Line 39: − + Line 45:
Line 45: − + Line 51:
Line 51: − + Line 111:
Line 111: +
no edit summary
Lets see an example in (Column1, Row2)
Lets see an example in (Column1, Row2)
<nowiki>=LEFT(R1C1,2)</nowiki>
<nowiki>=LEFT(B1C1,2)</nowiki>
LEFT returns JO.
LEFT returns JO.
Lets see an another example in (Column1,Row3)
Lets see an another example in (Column1,Row3)
<nowiki>=LEFT(R1C1)</nowiki>
<nowiki>=LEFT(B1C1)</nowiki>
LEFT returns J(if omitted,considered as 1).
LEFT returns J(if omitted,considered as 1).
Consider an example in (Column1, Row4)
Consider an example in (Column1, Row4)
<nowiki>=LEFT(R1C1,20)</nowiki>
<nowiki>=LEFT(B1C1,20)</nowiki>
LEFT returns JOHN SMITH(Number_chars> length of text).
LEFT returns JOHN SMITH(Number_chars> length of text).
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|}