Spreadsheet: 487312d1478017458-search-and-find-to-extract-some-text-from-a-string-of-text-used-report
Sheet: Purchase & Sale - USED (VS)

Car Description | Model |  |  |  |  | 107
107 Urban 3dr 2 tr | 107 |  |  |  |  | 108
[NAME] 5dr |  |  |  |  |  | 206
[NAME] 5dr |  |  |  |  |  | 207
zBMW 325Ti Compact |  |  |  |  |  | 208
[NAME] |  |  |  |  |  | 306
208 Active 1.2 3dr | 208 |  |  |  |  | 307
3008 Allure 1.6 HDI | 3008 |  |  |  |  | 308
108 Allure 1.2 5dr | 108 |  |  |  |  | 508 |  | These are the only car models I
zVauxhall Astra Club |  |  |  |  |  | 2008 |  | am intrested in
zMazda 2 5dr |  |  | The formulas would go in column B |  |  | 3008
208 Active 1.2 5dr | 208 |  | and in italic I have shown the answers I |  |  | 5008
107 Active 5dr |  |  | would expect. |  |  | Bipper
308 SW Active 1.6 HDI | 308 |  |  |  |  | [NAME]
2008 Active 1.4 HDI | 2008 |  |  |  |  | Expert
[NAME] | 308 |  |  |  |  | Partner
zAudi A4 |  |  |  |  |  | RCZ
zSaab 9-3
zPeugeot 207 SE 1.4 5dr | 207
207 Active 1.4 5dr | 207
z206 LX 3dr | 206
2008 Access + 1.2 | 2008
508 Active 2.0 BHDI
208 Style 1.2 5dr
[NAME]
107 Active 5dr
z3008 Exclusive 2.0 HDI
z107 Access 3dr
208 Allure 1.2 5dr
Bipper Prof 1.3 HDI 75
z206 LX 5dr
[NAME] 3dr
RCZ GT 1.6
208 Active 1.4 HDI 5dr
107 Allure 5dr
308 SW Allure 1.6 BHDI
z3008 Sport 1.6
208 Access + 1.2 5dr
208 Allure 1.4 vti 5dr
208 Allure 1.6 5dr Auto
2008 Allure 1.2
107 Envy 5dr
3008 Hybrid 4 SR 2.0 Auto
3008 Active 1.6 HDI S-A
z308 Allure C.C. 1.6
308 Active 1.2
308 Allure 1.6HDI versio
2008 Access + 1.2
208 Allure 1.6 5dr Auto
zPeugeot 206 LX 3dr
208 Allure 1.2 5dr
108 Active 1.0 5dr
zFiat Punto Easy 5dr
107 Sportium 3dr
208 Allure 1.2 5dr
5008 Active 1.6 HDI
Peugeot  Partner S 1.6 HDI
Peugeot 107 Active 5dr
208 Allure 1.2 3dr
3008 Allure 1.6 HDI S-A
308 GTL 1.2
508 SW GTL 2.0 BHDI
208 Access + 1.2 5dr
308 SW SE 1.6 HDI
Peugeot 308 SW GT 2.0 BHDI Auto
z307 S 1.4
zSaab 9-3 Convertible
[NAME]
zVauxhall Signum CDTI
zPeugeot 207 Sport 1.6 Auto 5dr
zHyundai Getz GSI 5dr
208 Active 1.4 HDI 5dr
zBMW 118 Sport Auto Conv
zPeugeot 307 SW S HDI
3008 Active 1.6 HDI S-A
zLand Rover Freelander Auto
[NAME]
2008 Active 1.6 HDI
108 Top Allure 1.2 5dr
208 Active 1.2 5dr S-A
Peugeot 208 Allure 1.2 5dr
2008 Allure 1.2
5008 Allure 1.6 HDI Semi-Auto
207 Active 1.4 5dr
208 Allure 1.2 5dr
[NAME] 5dr
208 GTL 1.2 5dr
108 Active 1.0 5dr
xSeat Exep Sport TSI Estate
107 Active 5dr 2tr
[NAME]
2008 Allure 1.2
207 Allure 1.6 5dr Auto
[NAME]
zMazda MX5 Convertible
2008 Allure 1.2 Auto
z106 3dr
308 Active 1.6 HDI
[NAME]
3008 Allure 2.0 HDI Auto
zPeugeot 406 SW S 2.0 HDi
z206 LX HDI 5dr
108 Active 1.0 5dr
Partner Tepee Outdoor 1.6 HDI
107 Active 5dr
108 Top Active 1.0 5dr
[NAME]
207 SW Sport 1.6 HDI
2008 Allure 1.2
3008 Allure 2.0 HDI Auto
308 Allure 1.6 HDI
208 Allure 1.2 3dr
207 Allure 1.6 5dr Auto
208 Access + 1.4 HDI 3dr
z107 Urban Move 5dr
Peugeot 107 Allure 5dr
208 Allure 1.6 HDI 3dr
3008 Allure 2.0 HDI Auto
[NAME] 1.8 5dr
z206 LX 5dr
[NAME] S 3dr
208 Active 1.4 HDI 5dr Semi-Auto
208 Allure 1.2 3dr
zMini Cooper Sidewalk Convertible
2008 Allure 1.6 Auto
3008 Active 1.6 HDI
z107 Urban 3dr 2tr
z207 SW Active 1.6 HDI
308 Active 1.2 130 5dr
207 Verve 1.4 5dr
Peugeot RCZ GT 2.0 HDI
208 Access + 1.2 5dr
2008 Active 1.2 VTI Semi-Auto
zCitroen C3 Exclusive Auto 1.6
Peugeot 308 SW Allure 1.2 Auto
308 SW Allure 1.6 BHDI
207 Allure 1.6 HDI 5dr
[NAME]
z206 Roland Garros 5dr
zSmart for two Pulse Auto
508 Active SW 2.0 HDI
zDaihatsu Terios estate auto
z807 Zenith HDI Auto
207cc Allure 1.6 HDI
208 Allure 1.6 BHDI 5dr
z206 S 3dr
107 Active 5dr
107 Urban 5dr
108 Active 1.0 5dr 2tr
z206 SW S
[NAME] TDCI 2.0
[NAME]
zNissan Note SVE Auto
108 Allure 1.2 5dr
5008 Exclusive 1.6 HDI S-A
208 Allure 1.2 5dr
3008 Allure 2.0 HDI Auto
2008 Allure 1.6 Auto
[NAME] estate
[NAME] 5dr
207 Envy 1.4 5dr
2008 Allure 1.6 BHDI
207 Sport 1.4 5dr
Ford S-Max TDCI
z206 LX 3dr
208 Active 1.2 3dr
208 Active 1.2 5dr
308 Active 1.2 Auto
208 Active 1.2 5dr
108 Top Allure 1.2 5dr
z1007 [NAME] 3dr
2008 Allure 1.2
z106 5dr
208 style 1.2 5dr
3008 Allure 1.6 HDI Semi-Auto
zRenault Captur Auto
zBMW 320 Sport
[NAME] 1.2
[NAME]
zRover 25 5dr
108 Active 1.0 5dr 2tr
[NAME]
zToyota Urban Cruiser VVT 5dr
308 SW Allure 2.0 BHDI Auto
z206 SW 2.0 HDI
308 SW GTL 1.2
208 Access + 1.2 5dr
5008 Allure 1.6 BHDI 120
208 Active 1.2 3dr
zBMW 320i Sport Conv Auto
5008 Exclusive 1.6 HDI
3008 Active 1.6 HDI Semi-Auto
308 GTL 2.0 BHDI
107 Allure 3dr
z107 Urban 5dr
108 Active 1.0 5dr 2tr
208 Allure 1.2 5dr
[NAME] 5dr
308 SE 1.6
308 SW Active 1.6 HDI
3008 Allure 2.0 HDI Auto
208 Access + 1.2 5dr
5008 Allure 1.6 HDI
z307 S 2.0 HDI
z206 SW 1.4
3008 Exclusive 1.6 HDI Semi-Auto
[NAME]
z206 Look 3dr
308 SW GT Line 2.0 BHDI
[NAME]
[NAME] Auto
3008 Allure1.6 BHDI
[NAME] 5dr
[NAME]
[NAME] 5dr Auto
[NAME] 5dr
[NAME] 3dr
z307 SW S 1.6
[NAME]
308 S 1.6
z106 5dr
107 Sportium 5dr
208 XY 1.6 HDI 3dr
208 Allure 1.2 5dr
2008 Access + 1.2
2008 Allure 1.2 130
Peugeot 207 SW Allure 1.6
208 XY 1.6 HDI 3dr
z207 SW Sport 1.6 HDI
zToyota IQ3 VVT 3dr
107 Active 5dr
208 Style 1.2 5dr
zToyota Aygo 5dr
207 Active 1.4 3dr
208 Allure 1.6 Auto 5dr
zVauxhall Astra SXI 1.6 3dr
5008 Sport 2.0 HDI Auto
308 S 1.6
107 Urban 5dr 2tr
Partner Tepee Outdoor 1.6 HDI
3008 Allure 1.6 HDI Semi-Auto
zCitroen C4 grand picasso HDI
z206 SW HDI
107 Active 5dr
208 Allure 1.2 5dr Auto
RCZ GT 1.6
207 S 1.4 HDI 3dr
508 SW Allure 2.0 HDI
zHyundai Trajet GSI TD
[NAME] HDI SWB
3008 Allure 2.0 HDI Auto
2008 Allure 1.6 Auto
207 Sport 1.6 HDI 5dr
2008 Allure 1.6 HDI
3008 Active 1.6 HDI
208 Access + 1.2 5dr
3008 Active 1.6 HDI
5008 Allure 2.0 HDI Auto
zChevrolet Spark LT 5dr
zSuzuki ignis 5dr
208 Active 1.2 5dr
[NAME] HDI 5dr
208 Style 1.2 5dr
107 Active 5dr
508 GT 2.0 BHDI Auto
zMazda 2 5dr
[NAME] 1.8
zHyundai Coupe v6
[NAME]
[NAME] 5dr
107 Allure 5dr
3008 Active 1.6 HDI
xDROP Rover 620 SI Auto
5008 Active 1.6 BHDI Auto
2008 Allure 1.6
208 Access + 1.2 5dr
208 Allure 1.2 82 5dr
508 SW Active 2.0 HDI
208 Access + 1.2 5dr
Bipper Tepee Outdoor 1.3 HDI 2tr
308 Sportium 1.2
3008 Allure 2.0 HDI Auto
107 Urban 3dr 2tr
z407 SW 2.0 HDI
107 Active 5dr
208 Active 1.2 5dr
308 Active 1.2 Auto
308 Allure 1.2 Auto
3008 Allure 1.6 HDI
108 Feline 1.2 5dr
Partner Prof HDI75 1.6
3008 Allure 1.6
[NAME]
208 Allure 1.2 5dr Auto
[NAME] 1.4 5dr
[NAME] 5dr
[NAME]
z206cc
[NAME] DCI Van
208 Style 1.2 5dr
108 Allure 1.2 5dr
208 Active 1.2 5dr
[NAME] TDI
108 Active 1.0 5dr 2tr
208 Active 1.2 5dr
308 SW Access 1.6 HDI
Ford KA 3dr
208 Allure 1.2 5dr
2008 Urban Cross 1.2
5008 Allure 1.6 HDI Semi-Auto
[NAME] SRI 3dr
z206 Look 1.4 5dr
[NAME]
zMazda RX-8
Partner Tepee S 1.6 HDI
[NAME]
3008 Allure 1.6 HDI
308 GT Line 1.2
3008 Allure 1.6 HDI
2008 Allure 1.2
207 CC 1.6
[NAME] 3dr
3008 Active 1.6 HDI
208 Active 1.2 3dr
[NAME]
zMini One Convertible
208 Allure 1.6 5dr Auto
207 GT 1.6 3dr
308 SW Allure 1.2
[NAME] estate
RCZ 1.6 GT 200
zVW Golf Estate SE 1.4 S-A
[NAME] SE
z307 S 1.6
108 Active 1.0 5dr
107 Allure 5dr
308 Active 1.6 HDI
208 Allure 1.6 3dr Auto
5008 Allure 2.0 HDI Auto
308 Allure 1.6 BHDI
308 Active nav 1.6 HDI
108 Allure 1.2 5dr
[NAME]
xDEMO 5008 Allure 2.0 BHDI
208 Access + 1.2 5dr
207 Envy 1.6 HDI 5dr
208 style 1.2 5dr
208 GTL 1.2 3dr
3008 Sport 1.6 Auto
108 Allure 1.2 5dr
zMazda CX-5
308 S 1.6 HDI
108 Active 1.0 5dr 2tr
zVauxhall Astra 1.6 5dr
zAlfa Romeo Giulietta
[NAME] 5d
[NAME] scenic
[NAME]
zPartner Quicksilver 2.0 HDI
[NAME]
zChevrolet Aveo 5dr
zChevrolet Aveo 1.4 Auto
2008 Urban Cross 1.2
308 SW Allure 1.2
207 Allure 1.6 5dr Auto
2008 Allure 1.6 HDI
208 Allure 1.2 5dr
107 Urban 5dr 2tr
3008 Active 1.6 HDI Semi-Auto
3008 Allure 1.2 130
208 Allure 1.6 5dr Auto
2008 Allure 1.6 HDI
107 Active 5dr
308 SW GT 2.0 BHDI Auto
208 Allure 1.2 5dr
2008 Allure 1.2
508 Allure 2.0 HDI Auto
208 Style 1.2 5dr
308 SW Allure 2.0 BHDI Auto
zVW Golf 5dr
308 Allure 1.6
208 Active 1.2 5dr
107 Envy 5dr
108 Active 1.0 5dr
2008 Allure 1.2 Auto
[NAME] 1.4 5dr
[NAME]
208 Active 1.2 5dr
z207 SW S 1.4
zAlfa romeo 156
[NAME]
308 S 1.6 Auto
[NAME] 1.4 3dr
[NAME]
208 Allure 1.6 HDI 5dr
3008 Exclusive 1.6 HDI Semi-Auto
Expert Prof 1.6 HDI
3008 Allure 2.0 HDI
208 Allure 1.2 5dr Auto
107 Allure 5dr
208 Allure 1.6 BHDI 5dr
208 GTL 1.2 110 3dr
[NAME] 1.4 5dr
Partner S 1.6 HDI Van
[NAME] TFSI 5dr
208 Access + 1.2 5dr
[NAME]
zRenault megane Auto
308 Allure 1.6 HDI
3008 Active 1.6 HDI
107 Envy 5dr
508 SW GT 2.0 BHDI Auto
107 Active 1.0 5dr
[NAME]
zmazda 2
208 Allure 1.2 5dr
[NAME] 2.0
107 Allure 3dr
208 Active 1.6 BHDI 5dr
Jaguar XF V6 Auto
108 Allure 1.2 5dr
208 Active 1.4 5dr
107 Active 1.0 5dr
zFiat Punto Active 5dr
[NAME] 3dr
RCZ GT 2.0 HDI
308 Active 1.6 HDI
2008 Allure 1.6 BHDI
zMercedes C250 CDI Auto
RCZ GT HDi 2.0
2008 Allure 1.2 Semi-Auto
Aygo Go! 5dr 1.0 VVT-i Man Air Con
2008 Feline 1.6 BHDI
508 Allure 2.0 BHDI
308 Allure 2.0 BHDI Auto
207 Sport 1.4 3dr
zJeep Cherokee Auto
2008 Allure 1.2
[NAME]
3008 Allure 1.6 HDI Semi-Auto
zBMW 320i M Sport Convertible
108 Top Allure 1.2 5dr
3008 Active 1.6 BHDI AT
z307 SW S 1.6 HDI
107 Envy 5dr
107 Millesim 5dr
z206 verve 3dr
[NAME] 5dr
2008 Active 1.2
108 Active 1.0 5dr
3008 Active 1.6 HDI
3008 Allure 1.6 HDI
308 Active 1.6 HDI
308 Active 1.6 HDI
308 Active 1.2 Auto
208 Style 1.2 5dr
308 Allure 1.2 Auto
308 SW GTL 1.2
3008 Active 1.6 HDI Semi- Auto
308 GTL 1.2
zFiat [NAME]
zVauxhall Astra
z308 S Auto
208 Allure 1.2 5dr Auto
208 Style PT82 3dr
[NAME]
107 Active 1.0 5dr
SERVICE 108 Active 1.0 5Dr 2TR
[NAME]
zToyota Corolla Auto
3008 Active 1.6 HDI
107 Allure 5dr
207 SW Active 1.6 HDI
107 Active 1.0 3dr
208 XS Lime 1.2 5dr
zMini Countryman Cooper 1.6
[NAME]
208 Access + 1.2 5dr
208 Active Ehdi 92 5dr
107 Allure 1.0 3dr
2008 Allure 1.6 Auto
Partner Tepee Allure 1.6 BHDI
508 Active 1.6 BHDI
[NAME] 3dr
Ford Mondeo TDCI
Honda CRV Auto
107 urban 5dr
208 XY 1.6 HDI 3dr
Fiat Grande Punto
206 Sport 3dr
Hyundai [NAME] 5dr
Hyundai [NAME] 5dr
Audi A4 TDI Conv
Volvo V40 SE 1.6
3008 Allure Blue Hdi 120
308 Access 1.6 HDI
108 TOP Allure 1.2 5dr
108 Allure 1.2 5dr
208 Active Ehdi 70 5dr
Kia Sportage CRDI Auto
z106 zest 3dr
[NAME]
2008 Allure 1.2
308 GTL 1.2
Partner Pro 1.6 HDI
[NAME] 1.4 3dr
Citroen DS4 Auto
107 Millesim 3dr
z206 CC
107 Allure 1.0 5dr
2008 Allure 1.6 BHDI
208 Access + 1.0 5dr
2008 Allure PT82
208 Access 1.0 VTI 3dr
208 Allure 1.2 5dr Auto
208 Active 1.2 3dr
308 Allure 1.2 Auto
208 Active 1.4 HDI 5dr
108 Allure 1.2 5dr
zBMW 330i Auto
107 Urban 1.0 3dr
208 Active 1.0 3dr
308 GTL 1.6 BHDI
208 Active 1.2 5dr
zMercedes A160
308 Active 1.2
107 Verve 3dr
208 Active 1.0 5dr
2008 Allure 1.6 BHDI
2008 Allure 1.2 Semi-Auto
2008 Allure 1.2
208 Allure 1.2 5dr Auto
2008 Allure 1.2
2008 Allure 1.6 BHDI
3008 Active 1.6 HDI
[NAME] VTR+ 5dr
108 Allure 1.2 3dr
5008 Allure 2.0 HDI
zToyota Aygo Blue 5dr
208 Active 1.2 5dr
208 Allure 1.6 HDI 3dr
[NAME] CRDI
208 Allure 1.6 5dr Auto
3008 Allure 1.6 BHDI
2008 Allure 1.6 HDI
2008 Allure 1.6 HDI
3008 Allure 1.6 BHDI
zVW Polo Match 1.4 5dr
2008 Allure 1.2
[NAME] 5dr
z206 SW 1.4 S
[NAME]
[NAME]
[NAME] HDI 1.6
208 Style 1.2 5dr
zNissan Micra 3dr
208 Access + 1.4 HDI S-A
RCZ 1.6 Red
308 Allure 1.2
208 Active 1.0 3dr
108 Top Allure 1.2 5dr
208 Style 1.2 5dr
308 Feline 1.6
3008 Allure 1.6 HDI
208 Active 1.2 5dr
3008 Allure PT130
3008 Allure 1.6 HDI S-A
zVW Golf SE 5dr 1.6
[NAME]
z307 SW S 2.0
z206 2.0 HDI 3dr
z206 HDI 5dr
[NAME]
308 SW GTL 2.0 BHDI Auto
207 SW S 1.4
2008 Allure 1.2
208 Active 1.2 5dr
108 Feline 1.2 5dr
208 Active 1.4 EHDI 5dr S-A
2008 Active 1.4 HDI
208 Access 1.0 3dr
107 Active 5dr
208 Active 1.4 5dr
3008 Active 1.6 HDI
[NAME] TDCI
zFord fiesta 3dr
[NAME]
zSeat Ibiza 5dr
z106 3dr
308 Allure 1.2 Auto
3008 Allure 1.6 HDI
208 Style 1.4 HDI 5dr
[NAME]
108 Allure 1.2 3dr
108 Active 1.0 5dr
3008 Allure 1.6 EHDI S-A
208 Active 1.2 5dr
2008 Allure 1.2
3008 Active 1.6 EHDI EGC
5008 Active 1.6 HDI S-A
208 Style 1.2 3dr
107 Active 5dr
308 Allure 1.2
308 GTL 1.6 BHDI
107 Active 5dr 2tr
2008 Allure 1.2 ETG
108 Active TOP 1.0 5dr
[NAME] 1.4 5dr
zMini Cooper S
Bipper S HDI
zVauxhall Astra Auto 5dr
3008 Allure 1.6 HDI
207 Verve 1.4 3dr
308 Active 1.2
208 Allure 1.4 5dr
z206 S S-A 1.4 5dr
208 Access + 1.2 5dr
308 S 1.6 Auto
zCitroen berlingo
108 Top Allure 1.2 5dr
[NAME] 3dr
208 Allure 1.2 5dr
208 RG 1.6 EHDI 5dr
2008 Allure 1.6 EHDI
2008 Allure 1.2
Ford Fiesta Auto
zVW Polo 5dr
zFiat Panda 5dr
3008 Allure 1.6 BHDI
[NAME]
[NAME]
zMini Cooper
zHonda Jazz 5dr Auto
[NAME]
[NAME]
107 urban 3dr
208 Active 1.2 5dr
207 Allure 1.6 5dr
208 Access + 1.2 5dr
Bipper Tepee 1.3 HDI Outdoor
3008 Allure 1.6 EHDI S-A
308 Feline 1.6 EHDI
308 GT 2.0 BHDI Auto
208 Active 1.2 5dr
208 Allure 1.2 5dr
508 Active SW Hdi 140
[NAME]
[NAME]
508 SW Active 1.6 HDI
RCZ GT 1.6
[NAME]
108 Allure 1.2 5dr
zMini Cooper Auto
[NAME] 5dr
107 Active 5dr
208 Style 1.2 5dr
108 Allure 1.2 5dr
308 GTL 1.2
2008 Allure 1.2
3008 Active 1.6 HDI
2008 Active 1.6 BHDI
zVauxhall Astra 1.6 SXI
zLandRover freelander auto
[NAME]
zVauxhall Astra
[NAME] 5dr
[NAME]
z205 GLD 5dr
308 GTI 1.6
208 Access + 1.2 5dr
Kia Rio
208 Active 1.2 5dr
208 Active 1.2 3dr
107 Active 5dr
308cc GT 1.6
107 Active 5dr
208 Allure 1.2 5dr
308 Allure EHdi 115
208 GTL 1.6 HDI 5dr
208 XY 1.6 HDI 3dr
[NAME] 5dr
107 Active 5dr
208 Allure 1.6 3dr Auto
2008 Allure 1.6 Auto
107 Envy 5dr
3008 Allure 1.6 HDI
208 Active 1.2 Vti 5dr
308 GT Line Bhdi 150
208 GTI Prestige
Bipper Prof 1.3 HDI 80
208 Active 1.2 5dr
2008 Feline 1.6 EHDI
208 XS Lime 1.2 5dr