Array Functions
Intermediate

TEXTAFTER the second delimiter

The instance number picks which hyphen to split after.

Task:

Purchase orders are written as PO-NUMBER-REVISION. In B2:B5 extract the revision — everything after the second hyphen.

Hints

+5 XPno-hints bonus

Solve it on your own to keep the bonus. Each hint gets one step closer to the formula.

Variations of TEXTBEFORE, TEXTAFTER

0/4

The same formula in the other shapes it takes at work.

  1. Get the domain out of an email address

    TEXTAFTER returns everything past a delimiter.

    Core
    Intermediate
  2. TEXTBEFORE: the part before the @

    The mirror image of TEXTAFTER.

    Beginner
  3. TEXTAFTER the last delimiter: a file name

    A negative instance number counts from the end.

    Intermediate
  4. TEXTAFTER the second delimiter

    The instance number picks which hyphen to split after.

    Intermediate

The data in this exercise

This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.

5 rows × 2 columns4 cells you fill in
AB
1PO referenceRevision
2PO-1180-REV3
3PO-77-REV1
4PO-20415-DRAFT
5PO-905-REV12
What this exercise teachesMay contain the answer

With no instance number, TEXTAFTER splits at the first hyphen and returns "1180-REV3". Asking for the 2nd skips the number, whatever its length, and lands on the revision.