Syntax
=RIGHT(string, [number_of_characters])
string- The text to extract from.
number_of_characters- Optional. How many characters to take (default 1).
RIGHT function in Google Sheets
RIGHT returns a set number of characters from the end of a text string. Use it for suffixes, file extensions, last digits and region codes.
Practice RIGHT
Task 1 of 1
Extract the 2-letter warehouse code from the end of the SKU. Answer in B2.
Tip: while typing a formula, click a cell or drag across cells to insert references. Press Enter to check, and Tab to accept a function suggestion.
RIGHT examples
Each example below runs against this sample sheet. The results are calculated by the same engine as the practice grid.
| A | B | C | |
|---|---|---|---|
| 1 | Raw name | SKU | Note |
| 2 | maya PATEL | ELC-0427-NY | Refund requested |
| 3 | leo rossi | FUR-1180-TX | Shipped |
| 4 | AVA KIM | OFC-0093-CA | Refund issued |
| Formula | Result | What it shows |
|---|---|---|
=RIGHT(B2, 2) | NY | Warehouse code at the end of the SKU. |
=RIGHT(B3, 7) | 1180-TX | Last seven characters. |
=RIGHT(A3, LEN(A3) - FIND(" ", A3)) | rossi | Last name: everything after the first space. |
Tips and common mistakes
- To take "everything after X", subtract X's position from the total length as in the last example.
Related functions
Learning step by step? RIGHT is covered in Lesson 22: LEFT, RIGHT & MID of the free course.