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
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.
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.
滑鼠選中內容,快速回饋問題
滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy