Join Dennis Taylor for an in-depth discussion in this video Combine data via concatenation, part of Excel 2016: Cleaning Up Your Data.
- [Instructor] In addition to using functions…like CONCAT or CONCATENATE or Text Join…to bring together information from different columns,…you can also use a feature referred to as concatenation,…although you don't see it that way in the help system.…We need to pull together the data from columns A, B, and C.…And we can do this by using the ampersand symbol,…that's the and symbol typically found…above the number seven key on most keyboards.…We want to bring together this data,…and in a particular order.…Notice there's a middle initial here.…We might have some issues with that.…
Let's make this column a bit wider, for the moment,…also zoom in, I'm using the Control key…and moving the mouse wheel.…We're going to write a formula here.…Rather than having this information in three columns,…as we see it in columns A, B, and C,…let's put these names together in reverse order…so we can sort by last name,…but ultimately take up less space.…So we need to get the data out of cell A2 first of all,…that's going to be the word Baker in this case.…
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