ƒxPlainFormulaThink in English. Formula in Excel.

FUNCTION CATALOGUE / TEXT

RIGHT Excel function

Returns characters from the end of text.

Correct sentence to use

Extract the last [number] characters from [text].

Modify this query in PlainFormula →

Example formula

=RIGHT(A2,4)

Returns characters from the right.

Syntax

RIGHT(text, [num_chars])

Argument signature: text, [num_chars]

Availability note

Commonly available in current Excel; verify platform and locale-specific behaviour.

Check Microsoft's Excel function documentation ↗

← Browse all functions