CONCATENATE vs TEXTJOIN
CONCATENATE glues texts one by one; TEXTJOIN joins a whole range with a delimiter and can skip blanks.
| CONCATENATE | TEXTJOIN | |
|---|---|---|
| Takes ranges | No, cell by cell | Yes |
| Delimiter | You type it between every part | Given once |
| Skip blanks | No | Yes, with TRUE |
Syntax and example
CONCATENATE
=CONCATENATE(text1, [text2], …)
=CONCATENATE(B2,", ",A2)
Joins several texts into one, like the & operator.
TEXTJOIN
=TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)
=TEXTJOIN(", ",TRUE,A2:A8)
Joins texts or whole ranges with the separator you choose.
Which one to use?
For two or three cells, CONCATENATE or the & operator. For lists, TEXTJOIN.
About Ads
This site uses Google AdSense to display ads. These ads help us keep WebHerramientas completely free. Ads are managed by Google and meet strict security and privacy standards.
Ads help us keep WebHerramientas free for everyone
Practice it
Solve the exercise on the sheet; it is checked instantly. See all lessons · Formula translator
TEXTJOIN
TEXTJOIN(delimiter, ignore_empty, range) joins a whole range with the delimiter you choose, such as ", ". With TRUE it skips blank cells.
In C2, join the names separated by a comma and a space, without gaps for the blank cells.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Attendees | List for the email | ||
| 2 | Ana | |||
| 3 | Luis | |||
| 4 | ||||
| 5 | Sofía | |||
| 6 | Diego | |||
| 7 | ||||
| 8 | Valeria | |||
| 9 |
Tip: while typing, click a cell or drag across several to insert their reference. F4 anchors the reference with $.
Frequently asked questions
- What is the difference between CONCATENATE and TEXTJOIN?
- CONCATENATE glues texts one by one; TEXTJOIN joins a whole range with a delimiter and can skip blanks.
- When should I use CONCATENATE or TEXTJOIN?
- For two or three cells, CONCATENATE or the & operator. For lists, TEXTJOIN.