Author: Oscar Cronquist Article last updated on May 04, 2022

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