Manuals/calci/LEFTB

From ZCubes Wiki
Revision as of 21:38, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''LEFTB'''(Text, Number_chars) where, '''Text''' - is the text string to extract. '''Number_chars''' - re...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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).


Syntax

Remarks

Examples

Description

Default Calci
Column1 Column2 Column3 Column4
Row1 JOHN SMITH
Row2 JO
Row3 J
Row4 JOHN SMITH
Row5
Row6
TABLE3 File:Calci1.gif

File:Bold.gif

File:Italic.gif

File:Normal.gif

File:Underline.gif

File:Border.gif

File:Numbers.gif

File:Sort.gif

File:Formatcells.gif

File:Graphs.gif

$