TEXTJOIN and CONCAT in Excel: Combine Text From Cells

First name in one column, last name in another, and you need “Mina Park” in a third. Or a list of tags in a column that should become one comma-separated line. Joining text by hand means retyping; CONCAT and TEXTJOIN do it with a formula that updates when the source changes. TEXTJOIN is the one to learn — it handles separators and empty cells, the two things that make manual joining painful.

What TEXTJOIN / CONCAT does

CONCAT sticks values together with no separator and no choices: =CONCAT(A2,B2) gives “MinaPark”. TEXTJOIN adds a separator you choose, lets you ignore empty cells, and takes a whole range at once: =TEXTJOIN(“, “,TRUE,A2:A6) gives “red, blue, green” with no trailing comma and no double separators where a cell was blank.

The syntax

=TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...) — =CONCAT(text1, [text2], ...)

  • delimiter — the separator between items, for example “, ” or ” – “. Use “” for no separator.
  • ignore_empty — TRUE skips blank cells; FALSE keeps an empty slot, which leaves double separators.
  • text1, text2, … — the cells or ranges to join. TEXTJOIN accepts a whole range at once.

Step-by-step example

Build full names from first and last names, then a comma list of tags.

  1. Click the cell for the full name.
  2. Type =TEXTJOIN(" ",TRUE,A2,B2) — a space separator, blanks ignored, first name then last name.
  3. Press Enter and copy down. A missing middle name leaves no double space, because ignore_empty is TRUE.
  4. For the tag list, type =TEXTJOIN(", ",TRUE,D2:D6) over the tag range — one formula joins all five cells.
  5. To join without any separator, use CONCAT instead: =CONCAT(A2,B2) — but check the result, because CONCAT never adds spaces on its own.

Worked example

First Last Full name
Mina Park Mina Park
Jae Kim Jae Kim
Sora Lee Sora Lee

TEXTJOIN with a space gives clean full names in one step. The same function with “, ” turns a column of tags into a single line for an export file — the two most common joining jobs, one function.

Common errors

#VALUE! from TEXTJOIN. The delimiter or ignore_empty argument is missing — TEXTJOIN needs all three core arguments. CONCAT takes two or more values and nothing else.

Double separators in the result. ignore_empty is FALSE (or missing) and a source cell is blank. Set it to TRUE unless you need the empty slot to keep its place.

Numbers lose their formatting. Joined numbers come out raw: 1234.5 instead of $1,234.50. Wrap the number in TEXT first: TEXTJOIN(" — ",TRUE,A2,TEXT(B2,"$#,##0.00")).

TEXTJOIN does not exist in this file. TEXTJOIN needs Excel 2019 or Microsoft 365. In older Excel, use CONCATENATE or the & operator instead — =A2&" "&B2 does the same job for two cells.

Tip

The & operator is still the fastest way to join two or three known cells with fixed text between them: =A2&” (“&B2&”)” reads clearly. Reach for TEXTJOIN when the list is a range, or when blanks need skipping.

TEXTJOIN with a line break inside a cell

Use CHAR(10) as the delimiter and TEXTJOIN stacks the items on separate lines inside one cell: =TEXTJOIN(CHAR(10),TRUE,A2:A5), then turn on Wrap Text for the cell. It is the cleanest way to build a multi-line address or a summary block that stays live — change a source cell and the block updates. One catch: the line breaks only show if Wrap Text is on, so if the result looks like one long line, that is the setting to check, not the formula.

Practice file

Download the TEXTJOIN / CONCAT practice file (.xlsx) — it contains first and last names with live TEXTJOIN formulas, a tag list joined with commas, and a line-break version, plus a blank sheet for you to try it yourself.

Google Sheets

Google Sheets supports TEXTJOIN and CONCAT with the same syntax, and JOIN is a Sheets-only shortcut for the same idea. The CHAR(10) line-break trick works in Sheets too, with Wrap Text on.

Example prices and figures are illustrative, not market data.