Join Dennis Taylor for an in-depth discussion in this video Use Flash Fill for faster combining and splitting, part of Excel 2016: Cleaning Up Your Data.
- [Instructor] We're looking at a worksheet…called Flash Fill, and that's the name…of a relatively new feature in Excel,…introduced in Excel 2013.…You'll find it on the Data tab in the Data Tools group,…Flash Fill, 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's also got a keystroke shortcut, Control + E.…So, look at the data in Column A.…Many times, this feature will take the place of…the Text to Columns feature found just to its left…on the Data Tab, and also some of the text functions.…
You might have seen examples of both of these features…in prior movies of this chapter.…Now, in Cell B2, right here, I want to see this name,…Amy Ryan, but only with the first letters of each name…capitalized, and I also want to reverse the order.…So here's the way I want to see it, Ryan comma space Amy.…Now, one of three different ways to use Flash Fill…is to complete one entry, start the next one,…I'm about to type a capital W, the first letter…
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