Excel Function Translator Logo
    The Excel Translator

    RIGHT

    Text

    Returns the last (rightmost) characters from a text string.

    Translations
    EnglishRIGHT
    FrenchDROITE
    SpanishDERECHA
    GermanRECHTS
    ItalianDESTRA
    PortugueseDIREITA
    DutchRECHTS
    PolishPRAWY
    RussianПРАВСИМВ
    TurkishSAĞ
    CzechZPRAVA
    HungarianJOBB
    SwedishHÖGER
    DanishHØJRE
    FinnishOIKEA
    Syntax
    RIGHT(text, [num_chars])

    Arguments

    • textThe text string
    • num_charsNumber of characters to extract (default 1)(optional)
    Examples
    =RIGHT("Hello",2)
    lo

    Returns last 2 characters

    =RIGHT(A1,4)
    Last 4 chars

    Extracts 4 characters from end of A1

    =RIGHT(A1,LEN(A1)-FIND(" ",A1))
    After space

    Gets text after first space

    Tips & Best Practices
    • •If num_chars is omitted, returns 1 character
    • •Useful for extracting file extensions
    • •Combine with LEN for dynamic extraction
    Common Mistakes
    • •Assuming RIGHT counts from a fixed position rather than from the end of the string, which breaks when text length varies
    • •Extracting a fixed number of characters expecting it to grab a specific field, when the source data isn't a consistent length
    • •Not accounting for trailing spaces - RIGHT happily includes them, throwing off the extracted result
    Related Functions
    LEFTPulls characters from the beginning of the text instead of the end
    MIDPulls characters from any starting position in the middle
    LENOften paired with RIGHT to calculate how many characters to pull based on total text length
    Frequently Asked Questions

    How do I get everything after the last space or a specific symbol?

    Combine RIGHT with LEN and FIND, for example =RIGHT(A1,LEN(A1)-FIND("@",A1)) to get everything after an @ symbol.

    Why does RIGHT return the wrong characters on some rows?

    The source text probably has trailing spaces or inconsistent length - run TRIM on the source first.

    Can RIGHT extract a variable length instead of a fixed number?

    Yes, use LEN combined with FIND or SEARCH to calculate the number of characters dynamically instead of hardcoding it.

    Need to translate a formula using RIGHT?

    Use our translator to convert your complete formula