From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,700 courses taught by industry experts.

Combine data with the TEXTJOIN, CONCAT, and CONCATENATE

Combine data with the TEXTJOIN, CONCAT, and CONCATENATE - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Combine data with the TEXTJOIN, CONCAT, and CONCATENATE

“

- [Instructor] When you're trying to combine data 2 from different locations in an Excel worksheet, 3 you might need to rely upon 4 some Excel functions. 5 Some of these are listed over in column H. 6 These are text functions. 7 If we go to the formulas tab 8 in the ribbon menu system 9 and click on "text," 10 you'll notice that there is 11 a function called CONCAT, 12 but there's also one called "Concatenate" 13 that has been, you might say, retired. 14 It's still available 15 but you don't see it in the list. 16 We'll show you how it's used 17 and how CONCAT, ultimately its replacement, 18 is much better. 19 And there's another function here 20 that we'll be using as well called "TEXTJOIN." 21 So in different ways, 22 we can use these functions. 23 Let's imagine that within 24 this organization here, 25 they have some products. 26 The items are listed in column A, 27 and they've decided to come up 28…

Contents