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

format and display text values. Use TEXTJOIN to Joins text values with a delimiter. For range arguments, drag from the start cell to the end cell in the same argument field, or click start and end cells in order. use "/" for delimiter, use TRUE for ignore_empty. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

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

Practice This Function

Practice in Sequential Mode Back to Function List