Separating multiple paragraphs of data from one cell in excel

E

eagiordano

New Member
Joined
Dec 7, 2020
Messages
13
Office Version
  1. 365
Platform
  1. Windows
Hello All.

I am looking to separate the following data into a certain format in excel. Currently the data is in one cell separated in paragraphs with titles. See below

---------

Case International IH
580, 1594, 1694, MXM120, MXM130, MXM140, MXM155, MXM175, MXM190

County
654, 754, 764, 774, 944, 964, 974, 1164, 1164TW, 1184TW

David Brown
1394, 1410, 1412, 1494, 1594, 1690, 1694

Fiat
M100, M115, M135, M160

Fordson
Major, Power Major, Super Major

Ford New Holland
230A, 231, 233, 234, 250C, 260C, 333, 334, 335, 345, 420, 445, 450, 455, 515, 530A, 531, 532, 535, 545, 550, 555, 575D, 650, 655, 675D, 750, 755, 2000, 2100, 2110, 2120, 2150, 2300, 2310, 2600, 2610, 2810, 2910, 3000, 3055, 3100, 3110, 3120, 3150, 3230, 3300, 3310, 3330, 3400, 3430, 3500, 3550, 3600, 3610, 3900, 4000, 4100, 4110, 4140, 4200, 4330, 4340, 4400, 4410, 4500, 4600, 4630, 4830, 5000, 5030, 5100, 5110, 5200, 5340, 5500, 5550, 5600, 5610, 5610S, 5640, 5700, 5900, 6410, 6500, 6600, 6610, 6610S, 6640, 6700, 6710, 6810, 6810S, 7000, 7100, 7200, 7410, 7500, 7600, 7610, 7610S, 7630, 7700, 7710, 7740, 7810, 7810S, 7840, 7910, 8000, 8030, 8160, 8200, 8210, 8240, 8260, 8340, 8360, 8530, 8560, 8600, 8630, 8700, 8730, 8830, 9000, 9200, 9600, 9700, TB100, TB120, TM115, TM120, TM125, TM130, TM135, TM140, TM150, TM155, TM165, TM165 Brazil, TM175, TM190, TS80, TS90, TS100, TS110, TS115, TW5, TW10, TW15, TW20, TW25, TW30, TW35

---------

The data listed above obviously changes from cell to cell but the format of having the title (Make) and data (Model) below is the same. All the models are separated by commas. I need to convert it into the following format in two columns. Each Model on individual rows with the Make listed beside it.

1607337652140.png


Thank you in advance for your help.

Regards,
eagiordano
 
Sort by date Sort by votes
I was thinking three columns something like this:

TestBase.xlsm
ABCDEFGHIJKL
111547Case International IH238, 248, 258, 268, 278, 288, 385, 395, 454, 474, 475, 484, 485, 485XL, 495, 495XL, Hydro 84
2FergusonFE35
3JCB805, 805B, 806, 806B, 806C, 807, 807B, 807C, 808, 808B
4Backhoe loaderThese are the ones that concern me, because it is unclear if they belong to JCB or if thy are separate entities.
53C Mk111, 3D Mk111How do you want to handle them?
6Earthmoving Equipment
7410, 415, 420, 425, 430
8Loading shovel
9140, 406, 412, 415, 420, 43
10Massey Ferguson35, 35X, 65, 133, 135, 148, 152, 158, 165, 168, 175, 178, 185, 188, 230, 230 US Built, 231, 235, 240, 243, 245, 250
11IndustrialSame situation here, is this a separate entity or part of MF?
1220, 20D, 20F, 30E, 30H, 40E, 50, 50B, 50E, 50EX, 50F, 50H, 50HX, 60H
Sheet1


but you can see that my lack of knowledge about what you are working with leads to confusion about where some of the groups belong and how they should be identified in the final results. So if you have any way of clarifying that so I can write code that tells vba how to manipulate the data. Then maybe we can move forward with this.
 
Upvote 0
Maybe like this:

TestBase.xlsm
ABCDEFGH
111547Case International IH238, 248, 258, 268, 278, 288, 385, 395, 454, 474, 475, 484, 485, 485XL, 495, 495XL, Hydro 84
2FergusonFE35
3JCB805, 805B, 806, 806B, 806C, 807, 807B, 807C, 808, 808B
4 PCB Backhoe loader3C Mk111, 3D Mk111
5PCB Earthmoving Equipment410, 415, 420, 425, 430
6PCB Loading shovel140, 406, 412, 415, 420, 43
7Massey Ferguson35, 35X, 65, 133, 135, 148, 152, 158, 165, 168, 175, 178, 185, 188, 230, 230 US Built, 231, 235, 240, 243, 245, 250
8MF Industrial20, 20D, 20F, 30E, 30H, 40E, 50, 50B, 50E, 50EX, 50F, 50H, 50HX, 60H
Sheet1
 
Upvote 0
Also, will there be more than the two items listed in column A (11547 & 11569) ? Will these numbers change?
 
Upvote 0
With the sheet set up like this:
demo.xlsm
ABCDEFGH
111547Case International IH238, 248, 258, 268, 278, 288, 385, 395, 454, 474, 475, 484, 485, 485XL, 495, 495XL, Hydro 84
2FergusonFE35
3JCB805, 805B, 806, 806B, 806C, 807, 807B, 807C, 808, 808B
4 PCB Backhoe loader3C Mk111, 3D Mk111
5PCB Earthmoving Equipment410, 415, 420, 425, 430
6PCB Loading shovel140, 406, 412, 415, 420, 43
7Massey Ferguson35, 35X, 65, 133, 135, 148, 152, 158, 165, 168, 175, 178, 185, 188, 230, 230 US Built, 231, 235, 240, 243, 245, 250
8MF Industrial20, 20D, 20F, 30E, 30H, 40E, 50, 50B, 50E, 50EX, 50F, 50H, 50HX, 60H
911569Case International IH580, 1594, 1694, MXM120, MXM130, MXM140, MXM155, MXM175, MXM190
10County654, 754, 764, 774, 944, 964, 974, 1164, 1164TW, 1184TW
11David Brown1394, 1410, 1412, 1494, 1594, 1690, 1694
12FiatM100, M115, M135, M160
13FordsonMajor, Power Major, Super Major
Sheet1


You can then use the code below:
See next post for correct code.

to produce this:

demo.xlsm
ABCD
211547MF Industrial20
311547MF Industrial20D
411547MF Industrial20F
511547MF Industrial30E
611547MF Industrial30H
711547MF Industrial40E
811547MF Industrial50
911547MF Industrial50B
1011547MF Industrial50E
1111547MF Industrial50EX
1211547MF Industrial50F
1311547MF Industrial50H
1411547MF Industrial50HX
1511547MF Industrial60H
1611547Massey Ferguson230
1711547Massey Ferguson230 US Built
1811547Massey Ferguson231
1911547Massey Ferguson235
2011547Massey Ferguson240
2111547Massey Ferguson243
2211547Massey Ferguson245
2311547Massey Ferguson250
2411569Case International IH580
2511569Case International IH1594
2611569Case International IH1694
2711569Case International IHMXM120
2811569Case International IHMXM130
2911569Case International IHMXM140
3011569Case International IHMXM155
3111569Case International IHMXM175
3211569Case International IHMXM190
3311569County654
3411569County754
3511569County764
3611569County774
3711569County944
3811569County964
3911569County974
4011569County1164
4111569County1164TW
4211569County1184TW
4311569David Brown1394
4411569David Brown1410
4511569David Brown1412
4611569David Brown1494
4711569David Brown1594
4811569David Brown1690
4911569David Brown1694
5011569FiatM100
5111569FiatM115
5211569FiatM135
5311569FiatM160
5411569FordsonMajor
5511569FordsonPower Major
5611569FordsonSuper Major
Sheet4
 
Last edited:
Upvote 0
This is the code:
VBA Code: 
Sub t()
Dim c As Range, i As Long, ssh As Worksheet, dsh As Worksheet, sr As Long, er As Long, spl As Variant
Set ssh = ActiveSheet
Set dsh = Sheets.Add(After:=Sheets(Sheets.Count))
    With ssh
        sr = ssh.Range("A:A").Find("11547", , xlValues, xlWhole).Row
        er = ssh.Range("A:A").Find("11569", , xlValues, xlWhole).Row
        For Each c In .Range("B" & sr, .Cells(er - 1, 2))
            spl = Split(c.Offset(, 1).Value, ", ")
            For i = LBound(spl) To UBound(spl)
                dsh.Cells(Rows.Count, 1).End(xlUp)(2) = 11547
                dsh.Cells(Rows.Count, 1).End(xlUp).Offset(, 1) = c.Value
                dsh.Cells(Rows.Count, 1).End(xlUp).Offset(, 2) = spl(i)
            Next
        Next
        For Each c In .Range("B" & er, .Cells(Rows.Count, 2).End(xlUp))
            spl = Split(c.Offset(, 1).Value, ", ")
            For i = LBound(spl) To UBound(spl)
                dsh.Cells(Rows.Count, 1).End(xlUp).Offset(1) = 11569
                dsh.Cells(Rows.Count, 1).End(xlUp).Offset(, 1) = c.Value
                dsh.Cells(Rows.Count, 1).End(xlUp).Offset(, 2) = spl(i)
            Next
        Next
    End With
End Sub
 
Upvote 0
Another option, with your original data.
VBA Code: 
Sub eagiordano()
   Dim Ar As Areas
   Dim UsdRws As Long, r As Long, i As Long, j As Long
   Dim Sp As Variant
   
   UsdRws = Range("B" & Rows.Count).End(xlUp).Row
   Range("B2:B" & UsdRws).TextToColumns Range("B2"), xlDelimited, , 0, 0, 0, 0, 0, 1, vbLf
   With Sheets("sheet2")
      For r = 2 To UsdRws
         Set Ar = Range("B" & r).Resize(, 1000).SpecialCells(xlConstants).Areas
         For i = 1 To Ar.Count
            For j = 2 To Ar(i).Count
               Sp = Split(Ar(i).Columns(j), ",")
               With .Range("C" & Rows.Count).End(xlUp).Offset(1)
                  .Resize(UBound(Sp) + 1).Value = Application.Transpose(Sp)
                  .Offset(, -1).Resize(UBound(Sp) + 1).Value = Ar(i).Columns(1).Value
                  .Offset(, -2).Resize(UBound(Sp) + 1).Value = Range("A" & r).Value
               End With
            Next j
         Next i
      Next r
   End With
End Sub
+Fluff v2.xlsm
AB
1
211547Case International IH 580, 1594, 1694, MXM120, MXM130, MXM140, MXM155, MXM175, MXM190 County 654, 754, 764, 774, 944, 964, 974, 1164, 1164TW, 1184TW David Brown 1394, 1410, 1412, 1494, 1594, 1690, 1694 Fiat M100, M115, M135, M160 Fordson Major, Power Major, Super Major Ford New Holland 230A, 231, 233, 234, 250C, 260C, 333, 334, 335, 345, 420, 445, 450, 455, 515, 530A, 531, 532, 535, 545, 550, 555, 575D, 650, 655, 675D, 750, 755, 2000, 2100, 2110, 2120, 2150, 2300, 2310, 2600, 2610, 2810, 2910, 3000, 3055, 3100, 3110, 3120, 3150, 3230, 3300, 3310, 3330, 3400, 3430, 3500, 3550, 3600, 3610, 3900, 4000, 4100, 4110, 4140, 4200, 4330, 4340, 4400, 4410, 4500, 4600, 4630, 4830, 5000, 5030, 5100, 5110, 5200, 5340, 5500, 5550, 5600, 5610, 5610S, 5640, 5700, 5900, 6410, 6500, 6600, 6610, 6610S, 6640, 6700, 6710, 6810, 6810S, 7000, 7100, 7200, 7410, 7500, 7600, 7610, 7610S, 7630, 7700, 7710, 7740, 7810, 7810S, 7840, 7910, 8000, 8030, 8160, 8200, 8210, 8240, 8260, 8340, 8360, 8530, 8560, 8600, 8630, 8700, 8730, 8830, 9000, 9200, 9600, 9700, TB100, TB120, TM115, TM120, TM125, TM130, TM135, TM140, TM150, TM155, TM165, TM165 Brazil, TM175, TM190, TS80, TS90, TS100, TS110, TS115, TW5, TW10, TW15, TW20, TW25, TW30, TW35
311568Case International IH 238, 248, 258, 268, 278, 288, 385, 395, 454, 474, 475, 484, 485, 485XL, 495, 495XL, Hydro 84 Ferguson FE35 JCB 805, 805B, 806, 806B, 806C, 807, 807B, 807C, 808, 808B Backhoe loader 3C Mk111, 3D Mk111 Earthmoving Equipment 410, 415, 420, 425, 430 Loading shovel 140, 406, 412, 415, 420, 430, 435 Massey Ferguson 35, 35X, 65, 133, 135, 148, 152, 158, 165, 168, 175, 178, 185, 188, 230, 230 US Built, 231, 235, 240, 243, 245, 250 Industrial 20, 20D, 20F, 30E, 30H, 40E, 50, 50B, 50E, 50EX, 50F, 50H, 50HX, 60H
411569Case International IH 580, 1594, 1694, MXM120, MXM130, MXM140, MXM155, MXM175, MXM190 County 654, 754, 764, 774, 944, 964, 974, 1164, 1164TW, 1184TW David Brown 1394, 1410, 1412, 1494, 1594, 1690, 1694 Fiat M100, M115, M135, M160 Fordson Major, Power Major, Super Major
Data


+Fluff v2.xlsm
ABC
1
211547Case International IH580
311547Case International IH1594
411547Case International IH1694
511547Case International IH MXM120
611547Case International IH MXM130
711547Case International IH MXM140
811547Case International IH MXM155
911547Case International IH MXM175
1011547Case International IH MXM190
1111547County654
1211547County754
1311547County764
1411547County774
1511547County944
1611547County964
1711547County974
1811547County1164
1911547County 1164TW
2011547County 1184TW
2111547David Brown1394
2211547David Brown1410
2311547David Brown1412
2411547David Brown1494
2511547David Brown1594
2611547David Brown1690
2711547David Brown1694
2811547FiatM100
2911547Fiat M115
3011547Fiat M135
3111547Fiat M160
3211547FordsonMajor
3311547Fordson Power Major
3411547Fordson Super Major
3511547Ford New Holland230A
3611547Ford New Holland231
3711547Ford New Holland233
Sheet2
 
Upvote 0
Solution
JLGWhiz said:
With the sheet set up like this:
demo.xlsm
ABCDEFGH
111547Case International IH238, 248, 258, 268, 278, 288, 385, 395, 454, 474, 475, 484, 485, 485XL, 495, 495XL, Hydro 84
2FergusonFE35
3JCB805, 805B, 806, 806B, 806C, 807, 807B, 807C, 808, 808B
4 PCB Backhoe loader3C Mk111, 3D Mk111
5PCB Earthmoving Equipment410, 415, 420, 425, 430
6PCB Loading shovel140, 406, 412, 415, 420, 43
7Massey Ferguson35, 35X, 65, 133, 135, 148, 152, 158, 165, 168, 175, 178, 185, 188, 230, 230 US Built, 231, 235, 240, 243, 245, 250
8MF Industrial20, 20D, 20F, 30E, 30H, 40E, 50, 50B, 50E, 50EX, 50F, 50H, 50HX, 60H
911569Case International IH580, 1594, 1694, MXM120, MXM130, MXM140, MXM155, MXM175, MXM190
10County654, 754, 764, 774, 944, 964, 974, 1164, 1164TW, 1184TW
11David Brown1394, 1410, 1412, 1494, 1594, 1690, 1694
12FiatM100, M115, M135, M160
13FordsonMajor, Power Major, Super Major
Sheet1


You can then use the code below:
See next post for correct code.

to produce this:

demo.xlsm
ABCD
211547MF Industrial20
311547MF Industrial20D
411547MF Industrial20F
511547MF Industrial30E
611547MF Industrial30H
711547MF Industrial40E
811547MF Industrial50
911547MF Industrial50B
1011547MF Industrial50E
1111547MF Industrial50EX
1211547MF Industrial50F
1311547MF Industrial50H
1411547MF Industrial50HX
1511547MF Industrial60H
1611547Massey Ferguson230
1711547Massey Ferguson230 US Built
1811547Massey Ferguson231
1911547Massey Ferguson235
2011547Massey Ferguson240
2111547Massey Ferguson243
2211547Massey Ferguson245
2311547Massey Ferguson250
2411569Case International IH580
2511569Case International IH1594
2611569Case International IH1694
2711569Case International IHMXM120
2811569Case International IHMXM130
2911569Case International IHMXM140
3011569Case International IHMXM155
3111569Case International IHMXM175
3211569Case International IHMXM190
3311569County654
3411569County754
3511569County764
3611569County774
3711569County944
3811569County964
3911569County974
4011569County1164
4111569County1164TW
4211569County1184TW
4311569David Brown1394
4411569David Brown1410
4511569David Brown1412
4611569David Brown1494
4711569David Brown1594
4811569David Brown1690
4911569David Brown1694
5011569FiatM100
5111569FiatM115
5211569FiatM135
5311569FiatM160
5411569FordsonMajor
5511569FordsonPower Major
5611569FordsonSuper Major
Sheet4
Click to expand...
Hi @JLGWhiz the only issue with this is the time it would take to arrange the data into the format above. There are also multiple lines of data with multiple reference numbers. I think @Fluff has offered a solution which can use the format the data is originally in. But thank you for your help - it is greatly appreciated. Regards, eagiordano
 
Upvote 0
Fluff said:
Another option, with your original data.
VBA Code: 
Sub eagiordano()
   Dim Ar As Areas
   Dim UsdRws As Long, r As Long, i As Long, j As Long
   Dim Sp As Variant
  
   UsdRws = Range("B" & Rows.Count).End(xlUp).Row
   Range("B2:B" & UsdRws).TextToColumns Range("B2"), xlDelimited, , 0, 0, 0, 0, 0, 1, vbLf
   With Sheets("sheet2")
      For r = 2 To UsdRws
         Set Ar = Range("B" & r).Resize(, 1000).SpecialCells(xlConstants).Areas
         For i = 1 To Ar.Count
            For j = 2 To Ar(i).Count
               Sp = Split(Ar(i).Columns(j), ",")
               With .Range("C" & Rows.Count).End(xlUp).Offset(1)
                  .Resize(UBound(Sp) + 1).Value = Application.Transpose(Sp)
                  .Offset(, -1).Resize(UBound(Sp) + 1).Value = Ar(i).Columns(1).Value
                  .Offset(, -2).Resize(UBound(Sp) + 1).Value = Range("A" & r).Value
               End With
            Next j
         Next i
      Next r
   End With
End Sub
+Fluff v2.xlsm
AB
1
211547Case International IH 580, 1594, 1694, MXM120, MXM130, MXM140, MXM155, MXM175, MXM190 County 654, 754, 764, 774, 944, 964, 974, 1164, 1164TW, 1184TW David Brown 1394, 1410, 1412, 1494, 1594, 1690, 1694 Fiat M100, M115, M135, M160 Fordson Major, Power Major, Super Major Ford New Holland 230A, 231, 233, 234, 250C, 260C, 333, 334, 335, 345, 420, 445, 450, 455, 515, 530A, 531, 532, 535, 545, 550, 555, 575D, 650, 655, 675D, 750, 755, 2000, 2100, 2110, 2120, 2150, 2300, 2310, 2600, 2610, 2810, 2910, 3000, 3055, 3100, 3110, 3120, 3150, 3230, 3300, 3310, 3330, 3400, 3430, 3500, 3550, 3600, 3610, 3900, 4000, 4100, 4110, 4140, 4200, 4330, 4340, 4400, 4410, 4500, 4600, 4630, 4830, 5000, 5030, 5100, 5110, 5200, 5340, 5500, 5550, 5600, 5610, 5610S, 5640, 5700, 5900, 6410, 6500, 6600, 6610, 6610S, 6640, 6700, 6710, 6810, 6810S, 7000, 7100, 7200, 7410, 7500, 7600, 7610, 7610S, 7630, 7700, 7710, 7740, 7810, 7810S, 7840, 7910, 8000, 8030, 8160, 8200, 8210, 8240, 8260, 8340, 8360, 8530, 8560, 8600, 8630, 8700, 8730, 8830, 9000, 9200, 9600, 9700, TB100, TB120, TM115, TM120, TM125, TM130, TM135, TM140, TM150, TM155, TM165, TM165 Brazil, TM175, TM190, TS80, TS90, TS100, TS110, TS115, TW5, TW10, TW15, TW20, TW25, TW30, TW35
311568Case International IH 238, 248, 258, 268, 278, 288, 385, 395, 454, 474, 475, 484, 485, 485XL, 495, 495XL, Hydro 84 Ferguson FE35 JCB 805, 805B, 806, 806B, 806C, 807, 807B, 807C, 808, 808B Backhoe loader 3C Mk111, 3D Mk111 Earthmoving Equipment 410, 415, 420, 425, 430 Loading shovel 140, 406, 412, 415, 420, 430, 435 Massey Ferguson 35, 35X, 65, 133, 135, 148, 152, 158, 165, 168, 175, 178, 185, 188, 230, 230 US Built, 231, 235, 240, 243, 245, 250 Industrial 20, 20D, 20F, 30E, 30H, 40E, 50, 50B, 50E, 50EX, 50F, 50H, 50HX, 60H
411569Case International IH 580, 1594, 1694, MXM120, MXM130, MXM140, MXM155, MXM175, MXM190 County 654, 754, 764, 774, 944, 964, 974, 1164, 1164TW, 1184TW David Brown 1394, 1410, 1412, 1494, 1594, 1690, 1694 Fiat M100, M115, M135, M160 Fordson Major, Power Major, Super Major
Data


+Fluff v2.xlsm
ABC
1
211547Case International IH580
311547Case International IH1594
411547Case International IH1694
511547Case International IH MXM120
611547Case International IH MXM130
711547Case International IH MXM140
811547Case International IH MXM155
911547Case International IH MXM175
1011547Case International IH MXM190
1111547County654
1211547County754
1311547County764
1411547County774
1511547County944
1611547County964
1711547County974
1811547County1164
1911547County 1164TW
2011547County 1184TW
2111547David Brown1394
2211547David Brown1410
2311547David Brown1412
2411547David Brown1494
2511547David Brown1594
2611547David Brown1690
2711547David Brown1694
2811547FiatM100
2911547Fiat M115
3011547Fiat M135
3111547Fiat M160
3211547FordsonMajor
3311547Fordson Power Major
3411547Fordson Super Major
3511547Ford New Holland230A
3611547Ford New Holland231
3711547Ford New Holland233
Sheet2
Click to expand...
Hi @Fluff. Thank you for your input. That code appears to work as required and will save me a lot of head scratching!

Is there a simple modification to eliminate unwanted spaces in the output model data as highlighted in the screenshot below? If this is complicated don't worry because I can just use the =Trim formula at the end.

1607510285575.png


Once again thanks for your help with this. It is really appreciated.

Regards,
eagiordano
 
Upvote 0
Just add a space after the comma on this line as shown
VBA Code: 
               Sp = Split(Ar(i).Columns(j), ", ")
 
Upvote 0
just for fun with Power Query
Power Query: 
let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    LF = Table.ExpandListColumn(Table.TransformColumns(Source, {{"raw", Splitter.SplitTextByDelimiter("#(lf)", QuoteStyle.Csv), let itemType = (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "raw"),
    Filter = Table.SelectRows(LF, each ([raw] <> "")),
    Modulo = Table.TransformColumns(Table.AddIndexColumn(Filter, "Index", 1, 1), {{"Index", each Number.Mod(_, 2), type number}}),
    IF0 = Table.AddColumn(Modulo, "Make", each if [Index] = 1 then [raw] else null),
    IF1 = Table.AddColumn(IF0, "Model", each if [Index] = 0 then [raw] else null),
    FillD = Table.FillDown(IF1,{"Make"}),
    FillU = Table.FillUp(FillD,{"Model"}),
    Distinct = Table.Distinct(FillU, {"Make", "Model"}),
    TSC = Table.SelectColumns(Distinct,{"Make", "Model"}),
    Split = Table.ExpandListColumn(Table.TransformColumns(TSC, {{"Model", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), let itemType = (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "Model"),
    Trim = Table.TransformColumns(Split,{{"Model", Text.Trim, type text}})
in
    Trim
MakeModel
Case International IH580
Case International IH1594
Case International IH1694
Case International IHMXM120
Case International IHMXM130
Case International IHMXM140
Case International IHMXM155
Case International IHMXM175
Case International IHMXM190
County654
County754
County764
County774
County944
County964
County974
County1164
County1164TW
County1184TW
David Brown1394
David Brown1410
David Brown1412
David Brown1494
David Brown1594
David Brown1690
David Brown1694
FiatM100
FiatM115
FiatM135
FiatM160
FordsonMajor
FordsonPower Major
FordsonSuper Major
Ford New Holland230A
Ford New Holland231
Ford New Holland233
Ford New Holland234
Ford New Holland250C
Ford New Holland260C
Ford New Holland333
Ford New Holland334
Ford New Holland335
Ford New Holland345
Ford New Holland420
Ford New Holland445
Ford New Holland450
Ford New Holland455
Ford New Holland515
Ford New Holland530A
Ford New Holland531
Ford New Holland532
Ford New Holland535
Ford New Holland545
Ford New Holland550
Ford New Holland555
Ford New Holland575D
Ford New Holland650
Ford New Holland655
Ford New Holland675D
Ford New Holland750
Ford New Holland755
Ford New Holland2000
Ford New Holland2100
Ford New Holland2110
Ford New Holland2120
Ford New Holland2150
Ford New Holland2300
Ford New Holland2310
Ford New Holland2600
Ford New Holland2610
Ford New Holland2810
Ford New Holland2910
Ford New Holland3000
Ford New Holland3055
Ford New Holland3100
Ford New Holland3110
Ford New Holland3120
Ford New Holland3150
Ford New Holland3230
Ford New Holland3300
Ford New Holland3310
Ford New Holland3330
Ford New Holland3400
Ford New Holland3430
Ford New Holland3500
Ford New Holland3550
Ford New Holland3600
Ford New Holland3610
Ford New Holland3900
Ford New Holland4000
Ford New Holland4100
Ford New Holland4110
Ford New Holland4140
Ford New Holland4200
Ford New Holland4330
Ford New Holland4340
Ford New Holland4400
Ford New Holland4410
Ford New Holland4500
Ford New Holland4600
Ford New Holland4630
Ford New Holland4830
Ford New Holland5000
Ford New Holland5030
Ford New Holland5100
Ford New Holland5110
Ford New Holland5200
Ford New Holland5340
Ford New Holland5500
Ford New Holland5550
Ford New Holland5600
Ford New Holland5610
Ford New Holland5610S
Ford New Holland5640
Ford New Holland5700
Ford New Holland5900
Ford New Holland6410
Ford New Holland6500
Ford New Holland6600
Ford New Holland6610
Ford New Holland6610S
Ford New Holland6640
Ford New Holland6700
Ford New Holland6710
Ford New Holland6810
Ford New Holland6810S
Ford New Holland7000
Ford New Holland7100
Ford New Holland7200
Ford New Holland7410
Ford New Holland7500
Ford New Holland7600
Ford New Holland7610
Ford New Holland7610S
Ford New Holland7630
Ford New Holland7700
Ford New Holland7710
Ford New Holland7740
Ford New Holland7810
Ford New Holland7810S
Ford New Holland7840
Ford New Holland7910
Ford New Holland8000
Ford New Holland8030
Ford New Holland8160
Ford New Holland8200
Ford New Holland8210
Ford New Holland8240
Ford New Holland8260
Ford New Holland8340
Ford New Holland8360
Ford New Holland8530
Ford New Holland8560
Ford New Holland8600
Ford New Holland8630
Ford New Holland8700
Ford New Holland8730
Ford New Holland8830
Ford New Holland9000
Ford New Holland9200
Ford New Holland9600
Ford New Holland9700
Ford New HollandTB100
Ford New HollandTB120
Ford New HollandTM115
Ford New HollandTM120
Ford New HollandTM125
Ford New HollandTM130
Ford New HollandTM135
Ford New HollandTM140
Ford New HollandTM150
Ford New HollandTM155
Ford New HollandTM165
Ford New HollandTM165 Brazil
Ford New HollandTM175
Ford New HollandTM190
Ford New HollandTS80
Ford New HollandTS90
Ford New HollandTS100
Ford New HollandTS110
Ford New HollandTS115
Ford New HollandTW5
Ford New HollandTW10
Ford New HollandTW15
Ford New HollandTW20
Ford New HollandTW25
Ford New HollandTW30
Ford New HollandTW35
 
Upvote 0
You must log in or register to reply here.

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top