Skip to content

Lessons in your language are coming soon. Formulas already work in your Excel language.

Lesson 5/6

Split names and emails

Exercise 1 of 4

In B2, take the first name from the full name.

About this lesson

Combine LEFT, MID and FIND to split full names and email addresses into their parts.

In this lesson

  1. In B2, take the first name from the full name.
  2. In B3, take Ben's last name.
  3. In B2, take the user name: everything before the @.
  4. In B3, take the domain: everything after the @.

Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.

fx

Type in B2 and press Enter to check.