Excel Function

TEXTJOIN

Joins text values with a delimiter.

TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)

Arguments

delimiter

Required

Enter a text value (wrap with quotes when needed).

ignore_empty

Required

Specify TRUE or FALSE.

text1

Required

Specify a reference range. You can drag or click start/end cells.

Practice Preview

Use TEXTJOIN to return the result with these settings (Delimiter: "/", Ignore empty: TRUE (ignore empty cells), Text 1: B2:B4 (Name in column B)). You can set ranges by dragging from the start cell to the end cell in the same argument field.

Example Table

#	AEmployee ID	BName	CEmail	DPayment Amount	EAmount Text
2	E001	Taro Tanaka	t.tanaka@example.com	1200	1200
3	E002	Hanako Suzuki	h.suzuki@example.com	980	980
4	E003	Ken Sato	k.sato@example.com	2450	2450
5	E004	Aya Takahashi	a.takahashi@example.com	3000	3000
6
7
8

How to Use (Formula)

=TEXTJOIN("/", TRUE, B2:B4)

Result

Taro Tanaka/Hanako Suzuki/Ken Sato

Practice This Function

Start Function Practice Back to Function List

TEXTJOIN FAQ

How do I use TEXTJOIN in Excel?

Use TEXTJOIN when you want to join values with a delimiter. Enter Delimiter, Ignore empty, Text 1 in that order, then add optional arguments when needed.

Where can I practice TEXTJOIN?

Use the "Start Function Practice" button to jump straight into TEXTJOIN drills.

What arguments does TEXTJOIN use?

The main arguments are Delimiter, Ignore empty, Text 1. Enter them in order.