Join Dennis Taylor for an in-depth discussion in this video Use the CONCAT and TEXTJOIN functions to combine data, part of Excel 2016: Cleaning Up Your Data.
- [Narrator] If you're using Office 365…and you've installed upgrades…that were introduced in 2016,…you've got access to two new functions in Excel.…One is called concat, the other one is called textjoin.…That's the name of the worksheet that we're using…here in our chapter five file.…Now, if these functions are available to you,…if you go to the formulas tab, you will see them…in the category called text,…and you'll see right here, concat,…and farther down the list, you will see textjoin.…
Now, if using the standard Excel 2016,…or, if you're using Excel 365 and you have not upgraded,…you will not see these functions here,…you will instead see concatenate.…That function is still available,…even though you don't see it in the list,…and it's an ideal function for doing…what we might want to do here, in column E.…Let me zoom in on this by holding down control,…moving the mouse wheel.…We'd like to create a new ID…comprised of these three cells,…with the existing concatenate function,…and you can use this even if…you have installed the new functions.…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Moving and inserting rows and columns of data with a simple drag
- Replacing data at the character level
- Converting dates with text functions
- Converting text data to values
- Using the CONCAT and TEXTJOIN functions to combine data
- Splitting data into columns via the Text to Columns feature
- Using Flash Fill for faster combining and splitting
- Checking and correcting spelling mistakes