Explanation

Flash Fill can recognize many useful patterns.

Example — Phone Number Formatting

Original:

Phone
9812345678
9876543210
9998887776

Desired format:

Formatted Phone
98123-45678
98765-43210
99988-87776

After entering the first formatted example, use Ctrl + E.

Example — Creating Employee IDs

Name	Employee ID
Amit Kumar	EMP-AMIT
Neha Sharma	EMP-NEHA
Rahul Singh
Priya Gupta

Flash Fill can recognize the pattern.

Important

Flash Fill is pattern-based, so always check the results before using them in important reports.

Practice

Create:

1. Employee ID
2. Short Name
3. Formatted Phone
4. Email ID

using Flash Fill.