Skip to content

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

Lesson 2/6

TEXTJOIN: join with a separator

Exercise 1 of 3

In C2, list the whole team in one cell, separated by a comma and a space.

About this lesson

TEXTJOIN joins a whole range into one cell with a separator of your choice, and can skip empty cells.

In this lesson

  1. In C2, list the whole team in one cell, separated by a comma and a space.
  2. In D2, build the full code from A2:C2, with dashes between the parts.
  3. What does TRUE do in TEXTJOIN(", ",TRUE,A2:A9)?

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.