Skip to content
Lesson 1/6

Join text with & and CONCAT

Exercise 1 of 3

In C2, join the first and last name with a space between them, using &.

About this lesson

Join text from several cells with the & operator or CONCAT, for example a first and a last name.

In this lesson

  1. In C2, join the first and last name with a space between them, using &.
  2. In C3, write Ben's name as "Okafor, Ben" with CONCAT.
  3. In D2, build the code from the prefix and the number, with a dash between them.

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 C2 and press Enter to check.