Article updated on May 02, 2018

The RIGHT function extracts a specific number of characters always starting from the right.

Excel Function Syntax

RIGHT(text,[num_chars])

Arguments

text Text string or a cell reference to a text string.
[num_chars] The number of characters to extract. Optional. If this argument is not entered only the first character is extracted.

Example