Excel Function

RIGHT

Returns rightmost characters from text.

RIGHT(text, [num_chars])

Arguments

text

Required

Enter a text value (wrap with quotes when needed).

num_chars

Optional

Enter a numeric value.

Practice Preview

format and display text values. Use RIGHT to Returns rightmost characters from text. use B2 for text, use 3 for num_chars. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=RIGHT(B2, 3)

Practice This Function

Practice in Sequential Mode Back to Function List