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