From the course: Excel Tips Weekly

Unlock this course with a free trial

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

Combine data using CONCATENATE, CONCAT, and TEXTJOIN functions and the ampersand (&) character

Combine data using CONCATENATE, CONCAT, and TEXTJOIN functions and the ampersand (&) character - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Combine data using CONCATENATE, CONCAT, and TEXTJOIN functions and the ampersand (&) character

- [Instructor] Excel has a number of different techniques for pulling data together from different locations. Not uncommon to see these locations next to one another in adjacent cells. Often, the technique will involve using a function, perhaps one called CONCATENATE. If you use Office 365, and you have installed the latest updates, you also have the capability of using a new function called CONCAT, ultimately this will replace CONCATENATE, and another function called TEXTJOIN. Another feature, another capability that's been around for awhile is simply using the ampersand symbol. So let's show these different techniques here. So, we've got some entries over in column A, we've got a whole list of products, they've all been identified by their item numbers, we're changing our identification system. We're now going to call it an ID number, and we're going to pull together that item number along with the codes we've been using for color and size and location to create an ID something like…

Contents