Excel Battle: CONCAT vs TEXTJOIN

Which Microsoft Excel function is better, CONCAT or TEXTJOIN? In this video, we'll put these two heavyweight functions into a 3 round main event. We will examine these key differences:
1 - Arguments
2 - Delimiter
3 - Ignore empty cells

Chapters:
00:00 - Introduction
00:23 - Main Event
00:44 - Round 1
02:14 - Round 2
04:01 - Round 3

[PaulEBrownbill]

Excellent short video again. I like TEXTJOIN as it has more functionality. Thanks Paul

[shyjumathew]

Excellent, expecting more videos in future, thanks

[xaquison]

TEXTJOIN FTW. Excellent video. Love the format.

[anne-mievanhulle]

For round 1 I would use & instead of a function

[stevejez]

Thanks for your work Jeff, TEXTJOIN or a simply & depending on task.

[XajiTaher]

Excellent video. I prefer Cancat but will aim to get to know both.

[gmac]

If it's just two columns you're combining, I think the easiest way to go would be, for example: =B9&C9

[jamesheetderks]

I use CONCAT (or CONCATENATE) for a lot of dates, so I'm not sure yet whether TEXTJOIN is a better fit for that. I'll try it out.

[carlo_migliari]

I use CONCAT but also &" "&