Excel 365 + Google Sheets · TEXTJOIN

Merge a whole list into one cell

Joins many cells into one, with the separator you choose.

The formula

=TEXTJOIN(", ", TRUE, A2:A5)

What each part means

", "Separator
TRUESkip empty cells
A2:A5What to join

Example

Before

	A	B
1	Team	Everyone
2	Ana
3	Luis
4	Marta
5	Tom

After

	A	B
1	Team	Everyone
2	Ana	Ana, Luis, Marta, Tom
3	Luis
4	Marta
5	Tom

Step by step

Click cell B2.
Type the formula: =TEXTJOIN(", ", TRUE, A2:A5)
Press Enter.

Where it works

Excel 365 and Excel 2021 or newer
Google Sheets
Excel for the web (free)

The same formula in other languages

English TEXTJOIN
Español UNIRCADENAS
Português UNIRTEXTO

Get 1 formula a day, free

Plus a free weekly planner template for Excel and Google Sheets. Unsubscribe in 1 click.

✓ Done! Check your inbox to confirm.

Want ready-made templates? See the Formulyo pack →

Keep learning

Find duplicatesSpot duplicates instantly GOOGLETRANSLATEGoogle Sheets translates for you SUMIFSAdd up only what matches your rules UNIQUERemove duplicates without deleting IFERRORHide every #DIV/0!% of totalThe $ that saves your formulas