From the course: Excel 2016 Essential Training
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Splitting and combining columnar data with Flash Fill
From the course: Excel 2016 Essential Training
Splitting and combining columnar data with Flash Fill
- If you saw the previous movie on splitting data, you saw how we could deal with data like this and split those names into separate columns using a text to columns feature. But on the sheet called Flash Fill, we're going to be using a relatively new tool available starting in Excel 2013. It's called Flash Fill and many times it's going to be faster and better, although it doesn't ultimately have as much flexibility as Text to Columns. If you slide over the Flash Film button on the Data tab, the description reads, "Automatically fill in values. Enter a couple of examples you want as output and keep the active cell in the column you want filled in." It doesn't tell us everything, but it sounds kind of interesting. Look at Column A. Two problems; the major one is we cannot sort this list by last name. The minor problem possibly; it's all uppercase. We'd prefer to have just the first letters capitalized. I'm going to insert a new column to the left of Column B; right-click insert. Now…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.