Manuals/calci/RIGHT
Jump to navigation
Jump to search
RIGHT(txt,noc)
where txt is the text string containing the characters that want to pull out and noc specifies the number of characters .
It brings the last character or characters in a text string, based on the number of characters that specify.
Note: RIGHT use the single-byte character set (SBCS)
- noc must be greater than or equal to zero.
- RIGHT displays all of text when noc is greater than the length of text.
- When noc is omitted, it is assumed to be 1.
RIGHT
Let’s see an example in (Column1 Row 1)
C1R1 = Stock Exchange
I.e. =RIGHT(C1R1,8) is Exchange
///rly =RIGHT(C1R1) is e
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | StockXPExchange | Exchange | e | |
| Row2 | ||||
| Row3 | ||||
| Row4 | ||||
| Row5 | ||||
| Row6 |
