Text to Coloumns Stech Excel

	B	C	D	E
1
2	Supplier No.	Supplier Name	Supplier Data	Transaction Amt. Rs.
3	501256	Gillian Allnutt	Auto*Engines Ltd.	110,279
4		Francis Godden		90,500
5		Christopher Cresswell		122,639
6	601457	Danny Brooks	Car*Chassis Co.	150,411
7		John Jenkins		187,781
8		Richard Allnutt		131,918
9	701850	Tessa Morrow	Drive*Train Systems	64,676
10		James Ricketts		97,210
11		Susan Dixon		82,500
12		Thomas Gordon		75,096
13	851926	David Walker	Vehicle *Electronics Inc.	112,433
14		Robin Hall		58,903
15		Kenneth Walter		150,393
16	920612	Edward Khan	Auto*Body Works	175,059
17		Nicholas Holloway		103,265
18	1020976	Delia Muhammad	TireHub *Solutions	104,405
19		Lesleyann Pope		31,483
20		Susan Carley		161,150
21		Damien Smith		134,819
22		Steven Wood		179,814
23	1477072	David Shiner	Motor*Lubricants Ltd.	43,118
24		Glenys Wright		155,513
25		Kate Pearce		177,347
26	258967	Robert Arnold	AutoSafety* Products	101,077
27		David Gow		94,638
28		Darren Brooks		178,512
29	410297	Nicholas Holloway	HighPerformance Motors	143,004
30		Mayank Ali		182,525
31		Glen Campbell		102,964
32	744088	Stephen Smith	Compact *Cars Corp.	19,942
33		Caroline Eccles		177,347
34		Steven Bell		102,964
35	501256	Colin Matthews	Auto*Engines Ltd.	110,279
36		Stephen Cohen		90,500
37		William Martin		122,639
38	601457	Michael Bell	Car*Chassis Co.	150,411
39		Roger Rust		187,781
40		Richard Perrott		131,918
41	701850	Robert Reed	Drive*Train Systems	64,676
42		Hin Bragg		97,210
43		Allyson Rush		82,500
44		Stephen James		75,096
45	851926	Rita Hill	Vehicle *Electronics Inc.	112,433
46		Deanna Wang		58,903
47		James White		150,393
48	920612	Jill Thompson	Auto*Body Works	175,059
49		Cheryl Glover		103,265
50	1020976	Gillan Clark	TireHub *Solutions	104,405
51		Antony Westlake		31,483
52		Hin Bragg		161,150
53		James Whitehead		134,819
54		Christina Pedley		179,814
55	1477072	Ronald Butler	Motor*Lubricants Ltd.	43,118
56		David Stewart		155,513
57		Gary Shaw		177,347
58	258967	Donald Barratt	AutoSafety* Products	101,077
59		Brendon Dyer		94,638
60		Stuart Brown		178,512
61	410297	Alen Dinan	HighPerformance Motors	143,004
62		Jacqueline Clamp		182,525
63		Susan Reay		102,964
64	744088	Andrew Phillips	Compact *Cars Corp.	19,942
65		Alan Davie		177,347
66		Penelope Freeland		102,964
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100