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