Skip to content
Lesson 6/6

TEXTBEFORE and TEXTAFTER

Exercise 1 of 4

In B2, take the user name before the @ with TEXTBEFORE.

About this lesson

TEXTBEFORE and TEXTAFTER take the part of a text before or after a character, such as the user name in an email address.

In this lesson

  1. In B2, take the user name before the @ with TEXTBEFORE.
  2. In B3, take the domain after the @ with TEXTAFTER.
  3. In B2, take the colour: the text after the last dash.
  4. In B2, take the first name before the space.

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.