Skip to content
Excel

RIGHT function in Excel

Returns the rightmost characters from a text value

=RIGHT(text, [num_chars])

RIGHT syntax and parameters

Two arguments, one required.

  • textstringRequired
  • num_charsnumberOptional

RIGHT examples

Formulas you'll actually reuse.

  1. The last four digits of a card or account number:

    =RIGHT(A2, 4)

    Result"4242"

  2. The domain part of an email — everything after the @:

    =RIGHT(B2, LEN(B2) - FIND("@", B2))

    Result"example.com"

RIGHT in Google Sheets

Same name — your formula ports as-is.

Try RIGHT in the playground

Edit the example — nothing to install.

Preloaded with the RIGHT formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.