Text Functions
Intermediate

RIGHT after a space: the last name

Count from the end: total length minus where the space is.

Task:

Same contact list, other half. In B2:B6 extract each person's last name — everything after the space.

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 LEFT, RIGHT, MID

0/4

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

  1. LEFT, RIGHT, and MID Functions

    Extract parts of text using LEFT, RIGHT, and MID functions.

    Core
    Intermediate
  2. LEFT up to a space: the first name

    When the length changes from row to row, let FIND work it out.

    Intermediate
  3. RIGHT after a space: the last name

    Count from the end: total length minus where the space is.

    Intermediate
  4. MID between two separators

    Pull the middle section out of a code when every part varies in length.

    Advanced

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.

6 rows × 2 columns5 cells you fill in
AB
1Full nameLast name
2Nadia Kerr
3Bartholomew Lane
4Li Wei
5Josephine March
6Raj Iyer
What this exercise teachesMay contain the answer

Everything after the space is the whole string minus everything up to and including it. Getting that count right is the whole exercise: one too many and you keep the space, one too few and you lose a letter.