Overview
Grammar | RIGHT(text,num_chars) | Returns the last or last several characters in the text, based on the number of characters you specify. |
Parameter 1 | Text | Text string or referenced cell containing characters to be extracted |
Parameter 2 | Num_chars | Number of characters you want to extract, which cannot be less than 0 |
Notes
The function supports two parameters. The first is of any type and the second is of the numeric type (that can be defaulted).
If the value of num_chars is greater than the text length, the RIGHT function returns all characters of the text. If num_chars is not specified, the default value 1 is used.
Example
| Formula | Result | Notes |
|---|---|---|
| RIGHT("It is interesting",6) | esting | |
| RIGHT("Share Holder") | r | |
| RIGHT("Huge sale",4) | sale |
Extracting the Hour-Minute-Second Date from the Year-Month-Day-Hour-Minute-Second Date
Add a formula column, name it, and enter the formula RIGHT(ingestTime,8) to extract hour-minute-second data, as shown in the following figure.
