Explanation
Flash Fill automatically detects a pattern from your example and fills the remaining cells.
Shortcut:
Ctrl + E
Example 1 — Extract First Name
|
Full Name |
First Name |
|
Amit Kumar |
Amit |
|
Neha Sharma |
Neha |
|
Rahul Singh |
|
|
Priya Gupta |
Type Amit and Neha manually.
Then select the next cell and press:
Ctrl + E
Excel recognizes the pattern and fills the remaining first names.
Example 2 — Create Email IDs
|
Name |
|
|
Amit Kumar |
|
|
Neha Sharma |
|
|
Rahul Singh |
|
|
Priya Gupta |
Enter the first examples and use Ctrl + E.
Practice
Use Flash Fill to create:
- First Names
- Last Names
- Email IDs
- Employee codes