SPLIT & TEXTJOIN practice exercises

SPLIT breaks text into separate cells at a delimiter, like a dash or comma. TEXTJOIN does the opposite: it combines a range into one cell with a separator. The & operator joins individual pieces.

Syntax

SPLIT(text, delimiter)  ·  TEXTJOIN(delimiter, ignore_empty, range)  ·  A2&" "&B2
SPLIT(text, delimiter)
Spills the pieces into the cells to the right.
TEXTJOIN(delimiter, TRUE, range)
Joins every cell of range with delimiter between them; TRUE skips empty cells.
&
Joins two pieces of text: A2&" - "&B2.

The practice data

Customer records with full names, emails, product codes (country-number-color) and messy city names. Every exercise below uses this sheet, and your answer goes in H2.

ABCD
1Full nameEmailProduct codeCity
2Ana Lopez[email protected]US-4417-RED new york
3Ben Ortiz[email protected]CA-0932-BLUTORONTO
4Cara Smith[email protected]US-1205-GRNchicago
5Dev Patel[email protected]UK-7781-BLKLondon
6Eva Ross[email protected]US-3390-REDsan diego

Worked example

=A2&" <"&B2&">"

Builds an email-style label: Ana Lopez <[email protected]>. Result:

Ana Lopez <[email protected]>

Your turn: 3 exercises

Type a formula and press Enter. It is checked by a real formula engine, so any correct approach counts.

1 Join all full names (A2:A6) into one cell, separated by a comma and a space.

H2

2 Split the product code in C2 into its 3 parts.

H2

3 Return the username (the part before @) of the email in B3.

H2

Master SPLIT & TEXTJOIN in the full course

Lesson 8 of 18 goes deeper, with more exercises in a real spreadsheet grid. Start with the first 4 lessons free, then unlock everything with Pro.

Start free See pricing

Common SPLIT & TEXTJOIN mistakes

FAQ

Does Excel have SPLIT?

No. Excel 365 has TEXTSPLIT, and older Excel uses Text to Columns. TEXTJOIN exists in both.

How do I add a line break between joined items?

Use CHAR(10) as the delimiter and turn on text wrapping.

Keep practicing