Initial Database

Account No. Amount Type

200684165 MQPML ATF MQ SPECIAL EVENTS FD Internal $10,065.49 CR 200684165 10,065.49 CR
201853058 MBL-MGI REPS TXN A/C Internal $0.00 CR 201853058 0.00 CR
202352225 NINE 2002 - TRUST A/C Internal $117,927.20 CR 202352225 117,927.20 CR
202649638 TXN - RFX NOV 06 Internal $1,558.09 CR 202649638 1,558.09 CR
206423089 ALMONDS 2007 - TXN A/C Internal $6,940.06 CR 206423089 6,940.06 CR
208743393 MAC EQUINOX - TRUST ACCOUNT Internal $88.00 CR 208743393 88.00 CR
211924246 TIMBER LAND TRUST 2007 Internal $43,617.12 CR 211924246 43,617.12 CR
212169635 NINE 2003 - TXN A/C Internal $0.00 CR 212169635 0.00 CR
213477359 TRUST - RFX COMMODITY Internal $565,936.93 CR 213477359 565,936.93 CR
214177453 FORESTRY 2008 - LAND S1017E Internal $0.00 CR 214177453 0.00 CR
214422560 TXN - CIR MAR 08 Internal $3,000.00 CR 214422560 3,000.00 CR
214430316 MQ MAC EQ ASIA 2 Internal $96.96 CR 214430316 96.96 CR
216335778 MFPML ATF RGV SOPH INV TRUST Internal $25,931.81 DR 216335778 25,931.81 DR
221114481 MDAF - TXN A/C Internal $47,366.62 CR 221114481 47,366.62 CR
Account No. Amount Type
200684165 10,065.49 CR
201853058 0.00 CR
202352225 117,927.20 CR
202649638 1,558.09 CR
206423089 6,940.06 CR
208743393 88.00 CR
211924246 43,617.12 CR
212169635 0.00 CR
213477359 565,936.93 CR
214177453 0.00 CR
214422560 3,000.00 CR
214430316 96.96 CR
216335778 25,931.81 DR
221114481 47,366.62 CR
 Names Card Numbers Lower Case Upper Case Proper Case
RAVI 4553 ravi RAVI Ravi
SHIVA 356721 shiva SHIVA Shiva
MOHIT 67123 mohit MOHIT Mohit
RUPA 22347 rupa RUPA Rupa
DEEPA 54387 deepa DEEPA Deepa
RAVI 13564 ravi RAVI Ravi
SHARMIN 24873 sharmin SHARMIN Sharmin
BABU 19834 babu BABU Babu
JALAL 28743 jalal JALAL Jalal
RAVI 18643 ravi RAVI Ravi
MAYANK 34576 mayank MAYANK Mayank
RAHUL 76453 rahul RAHUL Rahul
SUNIL 3652 sunil SUNIL Sunil
MEHAK 57812 mehak MEHAK Mehak
SAKSHI 3434 sakshi SAKSHI Sakshi
SAMEER 47621 sameer SAMEER Sameer
VIRENDER 96432 virender VIRENDER Virender
ROHIT 86523 rohit ROHIT Rohit
RAVI 7534 ravi RAVI Ravi
DEEPAK 87631 deepak DEEPAK Deepak
Card Length Product Codes Letters Numbers Middle
4 KPO232765 KPO 232765 O23
6 JPR187634 JPR 187634 R18
5 UTW129876 UTW 129876 W12
5 JPW187549 JPW 187549 W18
5 MPW187634 MPW 187634 W18
5 JAW167345 JAW 167345 W16
5 MQO183452 MQO 183452 O18
5 YRP923654 YRP 923654 P92
5 YUQ287543 YUQ 287543 Q28
5 EPU173652 EPU 173652 U17
5
5
4 Names First Name Last Name Full Name
5 Janvi Mehra Janvi Janvi Janvi Janvi
4 Sakshi Arora Sakshi
5 Mehak sharma Mehak
5 Mohit Manchanda Mohit
5 Manav Suhi Manav
4 Mayank Dhawan Mayank
5 Rahul Roy Rahul
Rohit Sharma Rohit
Deepti Jain Deepti
Meenakshi Rawat Meenakshi
Product Codes
232765 Code Letters Numbers
187634 A12ER789 12 789
129876 123WER4589 123 4589
187549 EDRTYGH79
187634 1258569875W
167345 KJH785UIO
183452 TGFT987654
923654 QAWSERTY45
287543 12547EDRF75896
173652 54WEDFBHJ58
Q7W8E9R5R4T2
Janvi
Sakshi
Mehak
Mohit
Manav
Mayank
Rahul
Rohit
Deepti
Meenakshi
Mehra
Arora
sharma
Manchanda
Suhi
Dhawan
Roy
Sharma
Jain
Rawat
SalesRep Small Letter Capital Letter Capitalize First Letter
Allan Ramos allan ramos ALLAN RAMOS Allan Ramos
Andrew Meyer andrew meyer ANDREW MEYER Andrew Meyer
Arturo Francis arturo francis ARTURO FRANCIS Arturo Francis
Austin Reynolds austin reynolds AUSTIN REYNOLDS Austin Reynolds
Ben Perez ben perez BEN PEREZ Ben Perez
Bernadette Page bernadette page BERNADETTE PAGE Bernadette Page
Beth Tucker beth tucker BETH TUCKER Beth Tucker
Bethany Pena bethany pena BETHANY PENA Bethany Pena
Billie Chandler billie chandler BILLIE CHANDLER Billie Chandler
Blake Bridges blake bridges BLAKE BRIDGES Blake Bridges
Bobbie Ryan bobbie ryan BOBBIE RYAN Bobbie Ryan
Brooke Horton brooke horton BROOKE HORTON Brooke Horton
Carla Mccormick carla mccormick CARLA MCCORMICK Carla Mccormick
Cassandra Franklin cassandra franklin CASSANDRA FRANKLIN Cassandra Franklin
Cecilia Manning cecilia manning CECILIA MANNING Cecilia Manning
Charlie Wood charlie wood CHARLIE WOOD Charlie Wood
Christina Fuller christina fuller CHRISTINA FULLER Christina Fuller
Christy Olson christy olson CHRISTY OLSON Christy Olson
Cindy Becker cindy becker CINDY BECKER Cindy Becker
Colleen Warren colleen warren COLLEEN WARREN Colleen Warren
Dan Peterson dan peterson DAN PETERSON Dan Peterson
Della Jensen della jensen DELLA JENSEN Della Jensen
Don Gonzales don gonzales DON GONZALES Don Gonzales
Donna Reid donna reid DONNA REID Donna Reid
Drew Rogers
Eddie Green
Edwin Malone
Elaine Ellis
Elbert Klein
Ellen Weaver
Elvira Bowman
Eric Rose
Ernest Davis
Felicia Jennings
Fernando Rowe
Guillermo Potter
Herman Williams
Iris Underwood
Isabel Cross
Ivan Adkins
Jaime Pearson
Jenny Garcia
Joey Wong
Johanna Boone
Kyle Carr
Lance Yates
Lee Mack
Lorraine Gibson
Lula Daniels
Lynette Brewer
Mable Lindsey
Marian Hill
Marion Glover
Max Rodgers
Nellie Joseph
Patty Thompson
Paulette Spencer
Pauline Beck
Peter Hodges
Rachel Gomez
Robert Munoz
Ruben Nunez
Salvador Bass
Sandra Floyd
Shari Silva
Sonya Mullins
Sylvester Morales
Tiffany May
Tracy Reed
Trevor Jones
Willie Vega
Woodrow Colon
Agent ID ID's Digit SalesRep Remove Un-ncecessary Space
AID_001 Olson Christy Olson Christy
AID_002 Peterson Dan Peterson Dan
AID_003 Lindsey Mable Lindsey Mable
AID_004 Carr Kyle Carr Kyle
AID_005 Gomez Rachel Gomez Rachel
AID_006 Cross Isabel Cross Isabel
AID_07 Chandler Billie Chandler Billie
AID_008 Morales Sylvester Morales Sylvester
AID_009 Gomez Rachel Gomez Rachel
AID_010 Tucker Beth Tucker Beth
AID_011 Silva Shari Silva Shari
AID_02 Rogers Drew Rogers Drew
AID_013 Francis Arturo Francis Arturo
AID_014
AID_0015
AID_016
AID_017
AID_018
AID_019
AID_020
AID_021
AID__022
AID_023
AID_024
AID_025
AID_026 Student Name First Name
AID_027 Manshi Sharma
AID_028 Simran Kumari
AID_029 Bijan Gope
AID_030 Sunanda Das
AID_031 Raj Kumar
AID_032 Shivani Chaturvedi
AID_033 Abilash Das
AID_034 Riya Banerjee
AID_035
AID_036
AID_037
AID_038
AID_039
AID_040
AID_041
AID_042
AID_043
AID_044
AID_045
AID_046
AID_047
AID_048
AID_049
AID_050
AID_051
AID_052
AID_053
AID_054
AID_055
AID_056
AID_057
AID_058
AID_059
AID_060
AID_061
AID_062
AID_063
AID_064
AID_065
AID_066
AID_067
AID_068
AID_069
AID_070
AID_071
AID_072
 Product ID Product State Invoice Number Product ID
FUR-BO-10001798
FUR-CH-10000454
OFF-LA-10000240
FUR-TA-10000577
OFF-ST-10000760
FUR-FU-10001487
OFF-AR-10002833
TEC-PH-10002275
OFF-BI-10003910
OFF-AP-10002892
FUR-TA-10001539
TEC-PH-10002033
OFF-PA-10002365
OFF-BI-10003656
OFF-AP-10002311
OFF-BI-10000756
OFF-ST-10004186
OFF-ST-10000107
OFF-AR-10003056
TEC-PH-10001949

Last Name Company Email-ID

Lenskart
Walmart
PepsiCo
Muthoot
BHEL
Sbi
Airtel
Reliance
Code Letters Numbers SERIAL NUMBER TEXT NUMBER
A12ER789 123ABC ABC 123
123WER4589 786SWR SWR 786
EDRTYGH79 SWZ654 SWZ 654
1258569875W ABC123 ABC 123
KJH785UIO DEF456 DEF 456
TGFT987654 574ABC ABC 574
QAWSERTY45 999SWR SWR 999
12547EDRF75896 ABC812 ABC 812
54WEDFBHJ58 SWZ810 SWZ 810
Q7W8E9R5R4T2 DEF190 DEF 190
333ABC ABC 333
766SWR SWR 766
ABC129 ABC 129
SWZ657 SWZ 657
Note: This feature is not available in Excel 2016 unless you have an Office 365 subscription. If you are an Office 365 subscrib
Customer Data
Cust ID First Name Last Name Address Line 1 Address Line 2 Address Line 3 District City
CTEB-10 Arjun Khatri 893 Pocket 1 Sector - 34 Rohini Delhi
CTEB-35 Deepak Ahuja 805 Pocket 6 Sector - 36 Rohini Delhi
CTEB-6 Anuj Anand 77 Pocket 4 Sector - 12 Rohini Delhi
CTEB-27 Devaang Patel 263 Pocket 7 Sector - 11 Rohini Delhi
CTEB-31 Sunil Agarwal 853 Pocket 9 Sector - 21 Rohini Delhi
CTEB-3 Alia Goel 395 Pocket 6 Sector - 11 Dwarka Delhi
CTEB-1 Mukesh Jain 317 Pocket 5 Sector - 9 Dwarka Delhi
CTEB-31 Ramakrishnana Reddy 191 Pocket 4 Sector - 13 Dwarka Delhi
CTEB-9 Divya Bakshi 321 Pocket 5 Sector - 22 Dwarka Delhi
CTEB-45 Keshav Babu 246 Pocket 8 Sector - 15 Dwarka Delhi
CTEB-19 Kunal Arya 655 Pocket 10 Sector - 15 Rohini Delhi
CTEB-35 Vijya Balakrishnan 507 Pocket 4 Sector - 15 Rohini Delhi
CTEB-3 Mukesh Banerjee 195 Pocket 3 Sector - 27 Dwarka Delhi
CTEB-41 Naveen Bhatt 493 Pocket 8 Sector - 16 Rohini Delhi
CTEB-22 Rishi Kumar 592 Pocket 10 Sector - 8 Rohini Delhi
CTEB-4 Baldev Kaushik 906 Pocket 11 Sector - 36 Dwarka Delhi
are an Office 365 subscriber, make sure you have the latest version of Office.
Fun
State Pin Code Country CONCATENATE
Delhi 110085 India Arjun Khatri Sector - 34DelhiIndia
Delhi 110085 India Deepak Ahuja Sector - 36DelhiIndia
Delhi 110085 India Anuj Anand Sector - 12DelhiIndia
Delhi 110085 India Devaang Patel Sector - 11DelhiIndia
Delhi 110085 India Sunil Agarwal Sector - 21DelhiIndia
Delhi 110075 India Alia Goel Sector - 11DelhiIndia
Delhi 110075 India Mukesh Jain Sector - 9DelhiIndia
Delhi 110075 India Ramakrishnana Reddy Sector - 13DelhiIndia
Delhi 110075 India Divya Bakshi Sector - 22DelhiIndia
Delhi 110075 India Keshav Babu Sector - 15DelhiIndia
Delhi 110085 India Kunal Arya Sector - 15DelhiIndia
Delhi 110085 India Vijya Balakrishnan Sector - 15DelhiIndia
Delhi 110075 India Mukesh Banerjee Sector - 27DelhiIndia
Delhi 110085 India Naveen Bhatt Sector - 16DelhiIndia
Delhi 110085 India Rishi Kumar Sector - 8DelhiIndia
Delhi 110075 India Baldev Kaushik Sector - 36DelhiIndia
 Functions
Sector - 34 Rohini & CONCAT
TEXTJOIN