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

Join data with the TEXTJOIN function and Flash Fill

From the course: Excel 2016: Tips and Tricks

Start my 1-month free trial

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…

Contents