From the course: Excel 2016: Tips and Tricks
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Join data with the TEXTJOIN function and Flash Fill
From the course: Excel 2016: Tips and Tricks
Join data with the TEXTJOIN function and Flash Fill
- On the worksheet called, Mixed Names, we've got some data in columns L, M, and N. For the moment, let's ignore the id. What we'd like to do, here, is join these names in column O. And we could proceed with one of two major approaches. We could be using the flash fill feature. If you saw the previous movie, you know, this feature is located on the data tab. And all though, it's often used to split data into separate columns, you can also use it to join data. I'd like to see the name right here, Baker, comma, space, Mark. And while I'm at it, I don't want it to be all upper case. So, I'll type, Baker, comma, space, Mark. Press control, enter so the active cell doesn't move and then use flash fill. You can use this key stroke short cut as well, control E. But as soon as I click flash fill, you see what's happening here, and that looks pretty good. Always be alert as to the accuracy of flash fill. Everything appears to be pretty good here, except the B in O'Brien is not capitalized. You…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
-
-
-
-
Sort data with single buttons4m 34s
-
Clean up spaces quickly with the TRIM function4m 37s
-
Identify and eliminate duplicates6m 21s
-
Split column data using Text to Columns and Flash Fill5m 26s
-
Join data with the TEXTJOIN function and Flash Fill4m 46s
-
Ensure unique entries with data validation rules5m 19s
-
Force typed dates to be weekdays only with data validation rules4m 31s
-
Display unique items from large lists5m 17s
-
-
-
-