File Name

Text_to_Columns_Flash_Fill_Practice.xlsx

Dataset

Customer Name	Customer Data	Phone	City
Amit Kumar	Amit,Kumar,Sirsa	9812345678	Sirsa
Neha Sharma	Neha,Sharma,Hisar	9876543210	Hisar
Rahul Singh	Rahul,Singh,Fatehabad	9998887776	Fatehabad
Priya Gupta	Priya,Gupta,Sirsa	9876501234	Sirsa
Simran Kaur	Simran,Kaur,Hisar	9811122233	Hisar

Tasks

Task 1 — Text to Columns

Split Customer Data using comma.

Create:

First Name | Last Name | City

Task 2 — Flash Fill

From Customer Name create:

• First Name
• Last Name

Task 3 — Email Creation

Create:

firstname.lastname@company.com

Example:

amit.kumar@company.com

Task 4 — Phone Formatting

Create:

98123-45678

format using Flash Fill.

Task 5 — Final Customer Database

Create:

First Name	Last Name	Email	Phone	City

Final Challenge

Take a messy customer list and prepare a clean Customer Master Sheet using both Text to Columns and Flash Fill.