How to Concatenate in Excel | Concatenate with Space, Comma or Other Delimiter

In this video I demonstrate four different methods for concatenating or joining text or numeric values using formula.

00:00 Introduction
00:12 Concatenate using the & character
00:43 Concatenate using the CONCATENATE function
01:20 Concatenate using the CONCAT function
02:05 Concatenate using the TEXTJOIN function
------------------------

[LozGooch]

Perfect and straight to the point ! Thank you!

[desquivelr]

I spent so much time just looking for this answer and no one ever talks about it! Thanks so much

[nayabkhil]

Thank you very straightforward and to the point, great job!

[keeloraz]

That was amazing. Very useful, thanks

[muhammadimranbukhari]

How to text join with auto inserting commas, but in excel 2010 version.

[persionrandom]

i want to put "and" before the last word how do i do it?