CONCATENATE VS CONCAT VS TEXTJOIN - Join Text From Different Cells Together In Excel

We cover how to join two or more items into one string in Excel using CONCATENATE, CONCAT and TEXTJOIN, ultimately evaluating which function is best. These functions reduce the need to manually connect text, therefore helping you save a lot of time. In this video, I cover 5 main examples of CONCATENATE, CONCAT and TEXTJOIN to give you a good idea of the main applications you need to know.

Access the file here:

Subscribe for weekly Excel tutorials, techniques and examples:

Please share this video with others that may find it useful:

Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!

ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.

For any enquiries, please contact:

Overview: (0:00)
Simple CONCATENATE: (0:36)
The Power Of CONCAT: (1:55)
Concatenating Words In A Sentence With TEXTJOIN: (2:46)
Ignoring Empty Text With TEXTJOIN: (3:45)
Concatenating Text With Conditions: (4:51)
Evaluation: (5:55)

[GreenCatQueen]

Just what I needed to know, very clearly explained. Perfect! Thanks!

[ubaidillahmuhammad]

nice. put an excel file in the description ====

[Dud]

I just wanted to know, that instead of using concat at the end for "Subscribe to the Excel Hub" can't we use "=TEXTJOIN(" ", TRUE, C46:D46, "the", F46:G46)"?
Anyway, it was a great video!