Excel Battle: CONCAT vs TEXTJOIN

[@PaulEBrownbill]

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

[@shyjumathew07]

Excellent, expecting more videos in future, thanks

[@ExcelU]

Thank you :)

[@anne-mievanhulle9915]

For round 1 I would use & instead of a function

[@gmac9641]

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

[@josealvesferreira1683]

Very good

[@ExcelU]

Thanks!

[@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.

[@martyhester811]

Thanks, easy video to follow.

[@xaquison]

TEXTJOIN FTW. Excellent video. Love the format.

[@jamesheetderks5782]

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_migliari81]

I use CONCAT but also &" "&

[@umarbk2664]

Text joint

[@DiannBaldo]

TEXTJOIN