Compare CONCATENATE vs TEXTJOIN

2 vs

Compare CONCATENATE vs TEXTJOIN side-by-side — differences, popularity and recommendation

Presets: VLOOKUP vs XLOOKUP SUM vs SUMIFS INDEX vs MATCH vs XLOOKUP IF vs IFS vs SWITCH COUNT vs COUNTA vs COUNTIF AVERAGE vs AVERAGEIF vs AVERAGEIFS MAX vs LARGE vs MIN TEXT vs TEXTJOIN vs CONCAT FILTER vs SORT vs UNIQUE ROUND vs ROUNDUP vs ROUNDDOWN

All functions Pick at least 2 functions

Feature

Text

=CONCATENATE()

Syntax

Text

=TEXTJOIN()

★ Winner

Syntax

Category

Text text

Popularity

60 / 100

50 / 100

Views

◉ 49 views

◉ 43 views

Output

Text

Version

All versions

Excel 2019

Volatile

Dynamic Array

Description

Learn how to concatenate text strings in Excel using the CONCATENATE function. Our step-by-step guide makes it easy to join two or more text strings into one.

The TEXTJOIN function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges.

Syntax

=: CONCATENATE(text1, [text2], ...)

=TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)

Arguments

2 Arguments

text1 text2 (Optional)

4 Arguments

delimiter ignore_empty text1 text2 (Optional)

Examples

Tips

★ Recommendation — Winner: =TEXTJOIN()

=TEXTJOIN() is recommended based on higher popularity, newer version and Dynamic Array support.

Winner: =TEXTJOIN()