反馈已提交

网络繁忙

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

  • Last update：  2023-08-22

    • 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

    FormulaResultNotes
    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.

    RIGHT.png

    Attachment List


    Theme： Advanced Data Analyis
    前の記事
    次の記事
    • いいね
    • 良くない
    • 閲覧しただけ
    中文（简体） 中文（繁體） English
    日本語

    フィードバック

    鼠标选中内容，快速反馈问题

    鼠标选中存在疑惑的内容，即可快速反馈问题，我们将会跟进处理。

    不再提示

    10s后关闭