RIGHT - Returning a Given Number of Right-Most Character(s)

Last update：August 22, 2023

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.

Previous

Next

Helpful
Not helpful
Only read

中文（简体）中文（繁體）日本語

English

滑鼠選中內容，快速回饋問題

滑鼠選中存在疑惑的內容，即可快速回饋問題，我們將會跟進處理。

不再提示

10s後關閉

Get
Help

*Problem Type

Incomprehensible Content Incorrect Content Incomplete Procedure Other Content Problems Doc Page Function Feedback

Cannot be empty

Problem Description

0/1000

Cannot be empty

Submitted successfully

Network busy