RIGHT Function in Apple Numbers: Extract a Text Suffix

=RIGHT(source-string, string-length)

A length greater than or equal to the source string length returns the entire string. Apple’s example RIGHT(606,2) yields text 06, which is why two trailing digits can include a zero; format returned suffixes as text and do not assume a number is produced. RIGHT(A2,0) is not an Apple-documented supported length. Apple RIGHT documentation.

The function’s current English documentation is in Apple Formulas and Functions Help 15.4, reviewed 2026-10-11. This is a documentation version, not proof that the formula first appeared in Numbers 15.4. Apple’s Functions Help welcome describes its use alongside iWork apps on Mac, iPhone, iPad and iCloud.com. The individual reference does not certify identical behavior on every older Numbers release or browser/device build. No Mac, iPhone, iPad, or iCloud Numbers session was executed for this guide. Where an older release matters, check its formula editor and retest the sample.

Examples below use references inside one Numbers table. Apple’s cell reference guide documents A2 and A2:A6 for the current table, and qualified forms such as Catalog::A2 or Sheet 2::Catalog::A2 for cells in other tables or sheets. Select the cell in the editor when unsure about the qualifier. Numbers is table-centric; don’t replace :: with an Excel worksheet !.

Apple’s syntax guide shows commas between arguments for locales that do not use a decimal comma. When the decimal separator is a comma, use semicolons between function arguments you type manually. This changes the delimiter, not the order or meaning of arguments. Formula names are case-insensitive when typed, although Apple shows them in uppercase.

Create a table named Catalog with one header row and these five text values. Enter the codes as text, not numeric cells, so the leading zero in row 4 survives import.

Put the formula into a free cell in column B of the same table and fill/copy down as indicated. The codes follow the documented example pattern two-letter region, hyphen, four-character identifier, hyphen, two-character revision. This is a teaching assumption, not a promise that real imported SKUs always follow that structure.

In B2 enter:

=RIGHT(A2,2)

Expected result: R1. Copy down and compare to this manually derived output:

The last two characters are revision labels only because the sample data uses that convention. =RIGHT(A2) has the expected result 1: the omitted length retrieves one character. =RIGHT("Catalog",20) returns Catalog by Apple’s whole-string rule.

Fixed-length extraction is inappropriate if some revisions are R10 instead of R1. With codes containing exactly two hyphens, the second of which begins the suffix, use:

=RIGHT(A2,LEN(A2)-FIND("-",A2,FIND("-",A2)+1))

For CA-2048-R1, the source length is 10 characters and the second hyphen sits at position 8, so the computed requested length is 2, yielding R1. For CA-2048-R10, the length is 11 and the second hyphen remains position 8, yielding a three-character result, R10. This advanced formula uses Apple’s documented FIND and LEN names. It deliberately assumes a second hyphen exists. With only one hyphen, a missing delimiter, or an empty suffix, do not rely on this formula: FIND may fail or the derived length may violate Apple’s documented ≥ 1 rule.

• Unexpected final character only: You may have omitted string-length; specify the needed number of characters.
• Error after copying: Confirm source cell, number of characters and any nested FIND result; RIGHT(A2,LEN(A2)-...) requires valid positive lengths.
• Wrong output such as 2 rather than R2: The extraction length is one when you wanted two. Use 2 for the fixed sample.
• Leading zeros in suffix: RIGHT returns text; do not immediately turn 06 into a numeric quantity if the zero matters.
• Trailing spaces: RIGHT counts the final characters present, which may include whitespace introduced by imports. Inspect the input; use TRIM only when it is safe to discard spacing.
• Other-table references: Select the intended source table in the formula editor instead of assuming its address is local.

Excel and Google Sheets also have a RIGHT function, and common positive-length examples often transfer conceptually. Do not assume every zero-length/empty-value case or localized delimiter behaves the same: Apple’s current documentation explicitly states a lower bound of 1 for string-length. Numbers’ qualified table reference syntax also differs from Excel’s sheet references. Recheck results if a formula was imported from Excel or Sheets.

• TEXTAFTER in Apple Numbers
• TEXTBETWEEN in Apple Numbers
• Apple LEFT reference — choose characters at the start instead.
• Apple MID reference — choose a range beginning within the string.

• Apple Numbers — function documentation
• Functions Help welcome
• cell reference guide
• syntax guide
• Apple LEFT reference
• Apple MID reference
• Apple FIND reference

Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in Apple Numbers.

• No genuine Apple Numbers screenshots are included; this guide does not use mock application images.