Excel 2019 New Features: TEXTJOIN & CONCAT (vs. CONCATENATE)

QuickBooks 30-day free trial + 30% off for 12 months:



Exploring the two new formulas in Microsoft Excel 2019 (also available in some 2016 insider's editions):
=CONCAT()
=TEXTJOIN()

And comparing them with the legacy =CONCATENATE()

[leighdesaram]

Hi Hector, Thank you for explaining the new formulas. I am doing an online course and have just come across CONCAT, and wondered what it was. I hadn't heard on concatenate either. But I feel I have a better understanding now. And its much quicker watching your video than trying to ask online tutors that take a good while to get back to you and then to not always understand when you do get through to them, is real frustrating to say the least. So once again, Thank you.

[tums]

Thank you. The clarity and examples were on point!!

[ZeeStreamYT]

Thank you for your video.
=TEXTJOIN allows to use ignore empty cells & delimiter.
What's the difference between =CONCAT and =CONCATENATE

[marshalljackson]

Thanks for the explanation of the new Excel TEXTJOIN function. Very helpful.

[annaupshaw]

This video was very helpful. Thank you! How are you getting your formula to show in the cell beside each one?

[cherposton]

Thank you so much. This has greatly helped. I know I'll be back, but I didn't know about TEXTJOIN! Thanks again!

[afrojinq]

This is a game changer. Thanks. How am I just hearing about TextJoin and Concat now? Thanks so much

[faisalkambrath]

thanks a lot i was exactly searching for textjoin formula, thanks again

[abidg]

Awesome video, pls make more videos on excel, make full series on excel from beginner to Advanced, your teaching style is simply awesome. Thanks

[angelagarrett]

I would love to learn more about formulas and formatting.

[TheShivass]

Thanks for giving this example. It helps me in interview

[davecheung]

Hi,   do you think it's easier to join the 2 cells by using the cell reference and & sign instead of CONCAT() or TEXTJOIN()? what should I use to join?
i.e.    =A2&B2&C2&D2

[tranduyhung]

I am using excel 2016 and there is no CONCAT function? MS has deteled this function????

[drivingparadox]

Thank you, helped me remember and apply TEXTJOIN()

[haboobgroup]

Excel 2019 version but uploaded in 2016??? MAKES SENSE