- Advanced Excel Tutorial
- Advanced Excel - Home
- Excel New Features
- Excel - Chart Recommendations
- Advanced Excel - Format Charts
- Advanced Excel - Chart Design
- Advanced Excel - Richer Data Labels
- Advanced Excel - Leader Lines
- Advanced Excel - New Functions
- Fundamental Data Analysis
- Excel - Instant Data Analysis
- Excel - Sorting Data by Color
- Advanced Excel - Slicers
- Advanced Excel - Flash Fill
- Powerful Data Analysis
- Excel - PivotTable Recommendations
- Powerful Data Analysis – 1
- Advanced Excel - Data Model
- Advanced Excel - Power Pivot
- Excel - External Data Connection
- Advanced Excel - Pivot Table Tools
- Powerful Data Analysis – 2
- Advanced Excel - Power View
- Advanced Excel - Visualizations
- Advanced Excel - Pie Charts
- Advanced Excel - Additional Features
- Advanced Excel - Power View Services
- Advanced Excel - Format Reports
- Advanced Excel - Handling Integers
- Other Features
- Advanced Excel - Templates
- Advanced Excel - Inquire
- Advanced Excel - Workbook Analysis
- Advanced Excel - Manage Passwords
- Advanced Excel - File Formats
- Excel - Discontinued Features
- Advanced Excel Useful Resources
- Advanced Excel - Quick Guide
- Advanced Excel - Useful Resources
- Advanced Excel - Discussion
Advanced Excel - Flash Fill
Flash Fill helps you to separate first and last names or part names and numbers, or any other data into separate columns.
Step 1 − Consider a data column containing full names.
Step 2 − Enter the first name in the column next to your data and press Enter.
Step 3 − Start typing the next name. Flash Fill will show you a list of suggested names.
Step 4 − Press Enter to accept the list.
Step 5 − Enter a last name in the next column, and press Enter.
Step 6 − Start typing the next name and press Enter. The column will be filled with the relevant last names.
Step 7 − If the names have middle names also, you can still use Flash Fill to separate the data out into three columns by repeating it three times.
Flash Fill works with any data you need to split into more than one column, or you can simply use it to fill out data based on an example. Flash Fill typically starts working when it recognizes a pattern in your data.
To Continue Learning Please Login
Login with Google