Also applies to:
RIGHTB
RIGHT returns the last character or characters in a text string, based on the number of characters you specify.
RIGHTB returns the last character or characters in a text string, based on the number of bytes you specify. This function is for use with double-byte characters.
Syntax
RIGHT(text,num_chars)
RIGHTB(text,num_bytes)
Text is the text string containing the characters you want to extract.
Num_chars specifies the number of characters you want RIGHT to extract.
Num_bytes specifies the number of characters you want RIGHTB to extract, based on bytes.
Remarks
Example (RIGHT)
The example may be easier to understand if you copy it to a blank worksheet.
Selecting an example from Help
|
|
Example (RIGHTB)
=RIGHTB("
",2)
equals ""