Text formula
TEXTJOIN in Excel and Google Sheets
Join text from several cells with a separator.
Syntax
=TEXTJOIN(delimiter, ignore_empty, text1, ...)- delimiter
- Separator, e.g. ", ".
- ignore_empty
- TRUE skips blank cells.
- text1
- Cells or ranges to join.
Example
| Row | A | B | C |
|---|---|---|---|
| 1 | First | Last | Full name |
| 2 | Anna | Berg |
C2 =TEXTJOIN(" ",TRUE,A2:B2)
Result: Anna Berg
Joins first and last name with a space.
Ready-to-copy formulas
Comma-separated list
=TEXTJOIN(", ",TRUE,A2:A20)
Tips
- For two cells, =A2&" "&B2 also works.
Need the whole spreadsheet?
Start from a free template with every formula already in place. Opening a template uses no credits.