Manuals/calci/LEFT

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	File:Copy-cube.gif
Row6

File:Calci1.gif

---