Product Sales
Account Product Jan Feb Mar Qtr 1 Code
668-50-3295 XYZ 93 94 85 272
844-50-3736 XYZ 99 69 76 244
672-50-8695 XYZ 36 96 94 226
109-45-7003 ABC 80 66 70 216
423-40-9810 DEF 86 55 74 215
135-50-2192 XYZ 91 70 45 206
823-55-9688 GHI 40 92 72 204
528-45-4553 ABC 68 43 93 204
597-55-1421 GHI 43 70 85 198
591-55-7882 GHI 34 98 63 195
135-45-8489 ABC 60 88 39 187
895-45-9544 ABC 14 70 95 179
784-55-9004 GHI 85 31 61 177
199-40-4276 DEF 23 74 73 170
507-50-4577 XYZ 20 50 97 167
639-55-9819 GHI 34 43 88 165
276-50-1271 XYZ 24 82 57 163
109-55-6681 GHI 0 93 69 162
455-55-1181 GHI 94 25 39 158
224-50-1583 XYZ 65 29 64 158
836-55-6204 GHI 45 57 52 154
Extract first three digits from account code.
Product Sales
Account Product Jan Feb Mar Qtr 1 Code
668-50-3295 XYZ 93 94 85 272
844-50-3736 XYZ 99 69 76 244
672-50-8695 XYZ 36 96 94 226
109-45-7003 ABC 80 66 70 216
423-40-9810 DEF 86 55 74 215
135-50-2192 XYZ 91 70 45 206
823-55-9688 GHI 40 92 72 204
528-45-4553 ABC 68 43 93 204
597-55-1421 GHI 43 70 85 198
591-55-7882 GHI 34 98 63 195
135-45-8489 ABC 60 88 39 187
895-45-9544 ABC 14 70 95 179
784-55-9004 GHI 85 31 61 177
199-40-4276 DEF 23 74 73 170
507-50-4577 XYZ 20 50 97 167
639-55-9819 GHI 34 43 88 165
276-50-1271 XYZ 24 82 57 163
109-55-6681 GHI 0 93 69 162
455-55-1181 GHI 94 25 39 158
224-50-1583 XYZ 65 29 64 158
836-55-6204 GHI 45 57 52 154
Extract last four digits from account code.
Product Sales
Account Product Jan Feb Mar Qtr 1 Code
668-50-3295 XYZ 93 94 85 272
844-50-3736 XYZ 99 69 76 244
672-50-8695 XYZ 36 96 94 226
109-45-7003 ABC 80 66 70 216
423-40-9810 DEF 86 55 74 215
135-50-2192 XYZ 91 70 45 206
823-55-9688 GHI 40 92 72 204
528-45-4553 ABC 68 43 93 204
597-55-1421 GHI 43 70 85 198
591-55-7882 GHI 34 98 63 195
135-45-8489 ABC 60 88 39 187
895-45-9544 ABC 14 70 95 179
784-55-9004 GHI 85 31 61 177
199-40-4276 DEF 23 74 73 170
507-50-4577 XYZ 20 50 97 167
639-55-9819 GHI 34 43 88 165
276-50-1271 XYZ 24 82 57 163
109-55-6681 GHI 0 93 69 162
455-55-1181 GHI 94 25 39 158
224-50-1583 XYZ 65 29 64 158
836-55-6204 GHI 45 57 52 154
Extract two digit product code (between two dashes).
Employees Names
FIRST LAST Full Name
AHMAD ZIA
BASHIR CHOHAN
BILAL SULEHRI
DILAWAR HUSSAIN
HASSAN NASIR
IMRAN ABBAS
IMRAN BUKHARI
MASOOD AHMAD
MUMTAZ AHMED
ZIA AHMAD
ALI ASGHAR
FIDA RASOOL
ZEESHAN NADEEM
SHAHZAIB KHAN
NADEEM ABBAS
ABDUL MATEEN
SAEED AHMED
ARSLAN AHMED
USMAN ARSHAD
Join First and Last name in proper case
Employees Email Data
Email Address Name
Ahmad_Zia@company.com
Bashir_Chohan@company.com
Bilal_Sulehri@company.com
Dilawar_Hussain@company.com
Hassan_Nasir@company.com
Imran_Abbas@company.com
Imran_Bukhari@company.com
Masood_Ahmad@company.com
Mumtaz_Ahmed@company.com
Zia_Ahmad@company.com
Ali_Asghar@company.com
Fida_Rasool@company.com
Zeeshan_Nadeem@company.com
Shahzaib_Khan@company.com
Nadeem_Abbas@company.com
Abdul_Mateen@company.com
Saeed_Ahmed@company.com
Arslan_Ahmed@company.com
Usman_Arshad@company.com
Extract name of employees from their email addresses in separate column.
Employees Names
Full Name First Last
Ahmad Zia
Bashir Chohan
Bilal Sulehri
Dilawar Hussain
Hassan Nasir
Imran Abbas
Imran Bukhari
Masood Ahmad
Mumtaz Ahmed
Zia Ahmad
Ali Asghar
Fida Rasool
Zeeshan Nadeem
Shahzaib Khan
Nadeem Abbas
Abdul Mateen
Saeed Ahmed
Arslan Ahmed
Usman Arshad
Extract First and Last name in separate columns.
Employee Names
* REMEMBER* to practice Tex
Full Name No. of Characters Names in Capital Letters
Ahmad Zia
Bashir Chohan
Bilal Sulehri
Dilawar Hussain
Hassan Nasir
Imran Abbas
Imran Bukhari
Masood Ahmad
Mumtaz Ahmed
Zia Ahmad
Ali Asghar
Fida Rasool
Zeeshan Nadeem
Shahzaib Khan
Nadeem Abbas
Abdul Mateen
Saeed Ahmed
Arslan Ahmed
Usman Arshad
Find number of characters used in each name.
Turn all names into capital letters.
* REMEMBER* to practice Text to column feature as well in this practice file.
