DATA SET TO PE
S.No. Name
1 John Smith
2 jane.doe@email.com
3 MichaelJohnson
4 Linda, Brown
5 Chris@lee
6 AMY.WILSON
7 Tim -Williams
8 EmmaDavis
9 Robert;Green
10 SarahClark
11 paul-adams
12 julie_martin
13 DavidWilson
14 ElizabethTaylor
15 Richard_Edwards
16 JessicaKing
17 DanielLee
18 Natalie,Moore
19 CharlieThomas
20 Sophia Harris
NOTE: dataset can be used to practice functions su
CONCAT(), TEXTJOIN(), and others in Exce
S.No.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
DATA SET TO PERFORM TEXT FUNCTIONS
Email Phone Number Address Department
john.smith@email.co
123-456-7890 123 Elm Street Sales
m
JANE.DOE@email.co
234 567 8901 45 maple ave marketing
m
mjohnson@email.com 345.678.9012 Apt 7, 67 pine Blvd HR
linda.b@email.com 456-789-0123 101 Oak Lane finance
chrisl@email.com 567 890-1234 98 Cedar street IT
Box 204, Redwood
amy.w@email.com 678-901-2345 it
Dr.
twilliams@email.com 789 012 3456 11 Ashwood Crescent SALES
edavis@email.com 8901234567 Apt. 14, Birch Rd Finance
robertg@email.com 901 234 5678 78 Willow Court H.R.
Office: 3, Spruce
sarahc@email.com 123456789 IT
Square
padams@email.com 987-654-3210 56 Poplar Boulevard MARKETING
julie@email.com 876 543 2109 22 Sycamore Lane hr
david.w@email.com 765.432.1098 Box 101 Pine Park Finance
etaylor@email.com 654-321-0987 Apt 2B, 88 Cypress St it
redwards@email.com 543 210 9876 9 Maple Crescent SALES
jking@email.com 432.109.8765 33 Elmwood Avenue Finance
Apt 6A, Oakridge
dlee@email.com 321-098-7654 Marketing
Park
natalie.m@email.com 210 987 6543 57 Spruce Blvd H.R
charliet@email.com 109-876-5432 12 Cedarwood Lane it
Box 3, Redwood
sharris@email.com 098.765.4321 FINANCE
Terrace
dataset can be used to practice functions such as TRIM(), PROPER(), UPPER(), LOWER(), LEFT(), RIGHT(), FIND(), MID(),
CONCAT(), TEXTJOIN(), and others in Excel. You can clean, organize, and extract data while learning various text functions.
Name Email Phone Number Address
John Smith john.smith@email.com123-456-7 123 Elm Street
Jane.Doe@Email.Com jane.doe@email.com 45 maple ave
Michaeljohnson mjohnson@email.com345.678.9012 Apt 7, 67 pine Blvd
Linda, Brown linda.b@email.com 456-789-0123 101 Oak Lane
Chris@Lee chrisl@email.com 567 890-1234 98 Cedar street
Amy.Wilson amy.w@email.com 678-901-2345 Box 204, Redwood Dr.
Tim -Williams twilliams@email.com 789 012 3456 11 Ashwood Crescent
Emmadavis edavis@email.com 8901234567 Apt. 14, Birch Rd
Robert;Green robertg@email.com 901 234 5678 78 Willow Court
Sarahclark sarahc@email.com 123456789 Office: 3, Spruce Squar
Paul-Adams padams@email.com 987-654-3210 56 Poplar Boulevard
Julie_Martin julie@email.com 876 543 2109 22 Sycamore Lane
Davidwilson david.w@email.com 765.432.1098 Box 101 Pine Park
Elizabethtaylor etaylor@email.com 654-321-0987 Apt 2B, 88 Cypress St
Richard_Edwards redwards@email.com 543 210 9876 9 Maple Crescent
Jessicaking jking@email.com 432.109.8765 33 Elmwood Avenue
Daniellee dlee@email.com 321-098-7654 Apt 6A, Oakridge Park
Natalie,Moore natalie.m@email.com 210 987 6543 57 Spruce Blvd
Charliethomas charliet@email.com 109-876-5432 12 Cedarwood Lane
Sophia Harris sharris@email.com 098.765.4321 Box 3, Redwood Terrac
Notes
Employee of the
month
pending promotion
special project lead
new hire
training completed
Completed
certification
Long leave approved
pending task
submission
-
New system training
System upgrade task
payroll task pending
On sabbatical
Upcoming project
lead
Pending meeting
), LEFT(), RIGHT(), FIND(), MID(),
hile learning various text functions.
Department Notes
Sales Employee of the month SalesEmployee of the month
Marketing pending promotion marketingpending promotion
Hr - HR-
Finance special project lead financespecial project lead
It new hire ITnew hire
It training completed ittraining completed
Sales SALES
Finance Completed certification FinanceCompleted certification
H.R. Long leave approved H.R.Long leave approved
It pending task submission ITpending task submission
Marketing - MARKETING-
Hr hr
Finance New system training FinanceNew system training
It System upgrade task itSystem upgrade task
Sales SALES
Finance payroll task pending Financepayroll task pending
Marketing On sabbatical MarketingOn sabbatical
H.R H.R
It Upcoming project lead itUpcoming project lead
Finance Pending meeting FINANCEPending meeting
