Manuals/calci/LEFTB
LEFTB(Text, Number_chars)
where,
Text - is the text string to extract.
Number_chars - represents the number of charcaters you want LEFT to extract.
LEFTB returns the first character or characters in a text string, based on the number of bytes you specify. LEFTB is intended for use with languages that use the double-byte character set (DBCS).
If Number_chars <= 0,LEFTB returns #ERROR.
If Number_chars > length of text, it returns all of text.
If Number_chars is omitted, it is considered as 1.
LEFTB
Lets see an example in (Column1, Row2)
=LEFTB(R1C1,2)
LEFTB returns JO.
Lets see an another example in (Column1,Row3)
=LEFTB(R1C1)
LEFTB returns J(if omitted,considered as 1).
Consider an example in (Column1, Row4)
=LEFTB(R1C1,20)
LEFTB returns JOHN SMITH(Number_chars> length of text).
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | JOHN SMITH | |||
| Row2 | JO | |||
| Row3 | J | |||
| Row4 | JOHN SMITH | |||
| Row5 | ||||
| Row6 |
| TABLE3 | File:Calci1.gif | $ |
