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(R1C1,2)
LEFT returns JO.
Lets see an another example in (Column1,Row3)
=LEFT(R1C1)
LEFT returns J(if omitted,considered as 1).
Consider an example in (Column1, Row4)
=LEFT(R1C1,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 |
