Spreadsheet: 288080d1389088017-i-need-to-select-and-seperate-markd-values-in-the-sheet-in-2007-example_2014
Sheet: Before

Address 1 | Address 2 | City | State | Province | Zip or Postal Code | Country | Member Type | Business Unit Intl | Sub-Industry Intl
 |  |  |  |  |  | AUS
377 Montague Rd |  | West End 4101 |  | Queensland | 4101 | AUS | Prospect | Services | [NAME]/HW
17 , [NAME]. | Frenchs Forest | Sydney |  | New South Wales | 2086 | AUS | Prospect | Services | [NAME]/HW
- |  | Sydney |  | New_South_Wales | 2747 | AUS | Prospect | Other
Summerhill park drive8 | 3138 | Melbourne |  | Victoria | 2478103 | AUS
. | . | . |  | New_South_Wales | 2135 | AUS | Prospect | Other
Hay st |  | West Perth |  | Western_Australia | 6005 | AUS
53 Britton Street |  | SMITHFIELD |  | NSW | 2164 | AUS | Prospect | Transportation / Distribution | Transport
53 Britton Street |  | SMITHFIELD |  | NSW | 2164 | AUS | Prospect | Transportation / Distribution | Transport
53 Britton Street |  | SMITHFIELD |  | NSW | 2164 | AUS | Prospect | Transportation / Distribution | Transport
21/75 [NAME] (docklands) |  | Melbourne |  | VIC | 3006 | AUS | Prospect | Services | [NAME]/HW
Level 8, 350 Collins Street |  | Melbourne |  | VIC | 3000 | AUS
U 1 | 1 Greenhills Ave | Moorebank |  | New South Wales | 2170 | AUS | Prospect | Manufacturing | [NAME]/HW
134 Bowman Street | Pyrmont | Sydney |  | New_South_Wales | 2009 | AUS
5/114 Flinders St |  | Melbourne |  | VIC | 3000 | AUS
950 Pacific Highway |  | Pymble |  | NSW | 2073 | AUS | Prospect | Manufacturing
950 Pacific Highway |  | Pymble |  | NSW | 2073 | AUS | Prospect | Manufacturing
950 Pacific Highway |  | Pymble |  | NSW | 2073 | AUS | Prospect | Manufacturing
950 Pacific Highway |  | Pymble |  | NSW | 2073 | AUS | Prospect | Manufacturing
48 Poole St |  | Murrayville |  | Victoria | 3512 | AUS | Prospect | Services | Media / Advertising
1c Bell St |  | Preston |  | Victoria | 3072 | AUS | Prospect | Services | [NAME]
107a Collins Street |  | Melbourne |  | Victoria | 3071 | AUS | Prospect | Services | [NAME]
U14 339 Williamstown Road |  | Port Melbourne |  | Victoria | 3207 | AUS | Prospect | Healthcare | [NAME]
154 Military Rd |  | Neutral Bay |  | New South Wales | 2089 | AUS | Prospect | Services | [NAME]
L 7 491 [NAME] |  | Sydney |  | New South Wales | 2000 | AUS | Prospect
L 7 491 [NAME] |  | Sydney |  | New South Wales | 2000 | AUS | Prospect | Services | [NAME]/HW
96mtgravatt-capalabard |  | Uppermountgravatt |  | QLD | 4122 | AUS
L 7 264 [NAME] |  | Sydney |  | New South Wales | 2000 | AUS | Prospect | Manufacturing | Large Format Speciality
2 Holker St U 6 |  | Newington |  | New South Wales | 2127 | AUS | Prospect | Services | [NAME]
110 Pacific Highway |  | St Leonards |  | NSW | 2065 | AUS | Prospect | Services | [NAME]
110 Pacific Highway |  | St Leonards |  | NSW | 2065 | AUS | Prospect | Retail | Convenience Stores
357 Ferntree Gully Rd |  | [NAME] |  | Victoria | 3149 | AUS | Prospect | Retail | Convenience Stores
 |  |  |  | Victoria | 3149 | AUS | Prospect | Retail | Convenience Stores
7 Eleven |  | True |  | Victoria | 3149 | AUS | Prospect | Retail | Convenience Stores
Private Bag 43 |  | MOUNT WAVERLEY |  | VIC | 3149 | AUS | Prospect | Retail | Convenience Stores
Private Bag 43 |  | MOUNT WAVERLEY |  | VIC | 3149 | AUS | Prospect | Retail | Convenience Stores
Private Bag 43 |  | MOUNT WAVERLEY |  | VIC | 3149 | AUS | Prospect | Retail | Convenience Stores
Private Bag 43 |  | [NAME] |  | Victoria | 3149 | AUS | Prospect | Retail | Convenience Stores
Private Bag 43 |  | MOUNT WAVERLEY |  | VIC | 3149 | AUS | Prospect | Retail | Convenience Stores
Private Bag 43 |  | MOUNT WAVERLEY |  | VIC | 3149 | AUS | Prospect | Retail | Convenience Stores
357 Ferntree Gully Rd |  | Mt Waverley |  | VIC | 3147 | AUS | Prospect | Retail | Convenience Stores
x |  | m |  | Victoria | 3000 | AUS | Prospect | Services | [NAME]/HW
60 Barker Rd |  | Strathfield |  | New South Wales | 2135 | AUS | Prospect | Services | [NAME]
Shed 9a Ingleston Rd |  | Wakerley |  | Queensland | 4154 | AUS | Prospect | Services | [NAME]
Weston |  | Creek |  | Australian Capital Territory | 2611 | AUS | Prospect | Manufacturing | Construction / DIY
20 Kendall St |  | Elwood |  | Victoria | 3184 | AUS | Prospect | Services | [NAME]/HW
80 Bonds Rd |  | Judbury |  | Tasmania | 7109 | AUS | Prospect | Services | [NAME]
26 Cochranes Road |  | Moorabbin |  | Victoria | 3189 | AUS | Prospect | Services | [NAME]
22 Nundah St |  | [NAME] |  | New South Wales | 2066 | AUS | Prospect | Manufacturing | Mining, quarrying & metals
157 Church St Cnr Church & Well St |  | Ryde |  | New South Wales | 2112 | AUS | Prospect | Retail | Automotive & Aerospace
56 Ipswich Road |  | Woolloongabba |  | Queensland | 4102 | AUS | Prospect | Retail | Automotive & Aerospace
 |  |  |  | Queensland |  | AUS | Prospect | Manufacturing | Food, Beverages and Tobacco
90 [NAME] |  | Colmslie |  | Queensland |  | AUS | Customer | Manufacturing | Food, Beverages and Tobacco
90 COLMSLIE RD |  | BRISBANE |  | QLD | 4170 | AUS | Customer | Manufacturing | Food, Beverages and Tobacco
90 COLMSLIE RD |  | BRISBANE |  | QLD | 4170 | AUS | Customer | Manufacturing | Food, Beverages and Tobacco
PO Box 54 |  | MORNINGSIDE |  | QLD | 4170 | AUS | Customer | Manufacturing | Food, Beverages and Tobacco
 |  | Morningside |  | Queensland | 4170 | AUS | Customer | Manufacturing | Food, Beverages and Tobacco
90 [NAME] |  | Colmslie |  | Queensland |  | AUS | Customer | Manufacturing | Food, Beverages and Tobacco
PO BOX 54 |  | Morningside |  | QLD | 4170 | AUS | Customer | Manufacturing | Food, Beverages and Tobacco
PO Box 54 |  | MORNINGSIDE |  | QLD | 4170 | AUS | Customer | Manufacturing | Food, Beverages and Tobacco
[NAME] 54 |  | Morningside |  | Queensland | 4170 | AUS | Customer | Manufacturing | Food, Beverages and Tobacco
90 [NAME] |  | Brisbane |  | Queensland | 4170 | AUS | Customer | Manufacturing | Food, Beverages and Tobacco
PO Box 54 |  | MORNINGSIDE |  | QLD | 4170 | AUS | Customer | Manufacturing | Food, Beverages and Tobacco
 |  | Brisbane |  | Queensland | 4170 | AUS | Customer | Manufacturing | Food, Beverages and Tobacco
90 [NAME] |  | Colmslie |  | Queensland | 4170 | AUS | Customer | Manufacturing | Food, Beverages and Tobacco
90 COLMSLIE RD |  | BRISBANE |  | QLD | 4170 | AUS | Customer | Manufacturing | Food, Beverages and Tobacco
90 [NAME] |  | COLMSLIE |  | QLD | 4170 | AUS | Customer | Manufacturing | Food, Beverages and Tobacco
190 Wells Street |  | South Melbourne |  | Victoria | 3205 | AUS | Prospect | Services | [NAME]
Level 1, 406-408 Collins Street |  | Melbourne |  | Victoria | 3000 | AUS | Prospect | Manufacturing | [NAME]
1 Lakeside Dr |  | Burwood East |  | Victoria | 3151 | AUS | Prospect | Manufacturing
 |  | Burwood East |  | Victoria | 3151 | AUS | Prospect | Manufacturing
145 Abbotts Rd |  | Dandenong South |  | Victoria | 3175 | AUS | Prospect | Manufacturing | Construction / DIY
145 Abbotts Rd |  | Dandenong South |  | Victoria | 3175 | AUS | Prospect | Manufacturing | Construction / DIY
Mersey Rd |  | OSBORNE |  | SA | 5017 | AUS | Prospect
358 [NAME] |  | Ballarat |  | Victoria | 3350 | AUS | Prospect | Retail | Construction / DIY
Beacon |  | Hill |  | New South Wales | 2100 | AUS | Prospect | Services | [NAME]
3 Greenhills Ave |  | Moorebank |  | New South Wales | 2170 | AUS | Prospect | Education | [NAME]
[NAME] |  | Melbourne (st Kilda Road) |  | Victoria | 3004 | AUS | Prospect | Transportation / Distribution | Hospitality / Leisure
161 163 Maitland Rd |  | Mayfield |  | New South Wales | 2304 | AUS | Customer
10 Queen Street | [NAME] | Adelaide |  | South_Australia | 5031 | AUS
2 Tripoli Mews |  | [NAME] |  | Western Australia | 6028 | AUS | Prospect | Healthcare
P.o. Box 1740 |  | [NAME] |  | Western_australia | 6531 | AUS | Prospect | Manufacturing
AA |  | Wentworthville |  | New South Wales | 2145 | AUS | Prospect | Services | [NAME]
23 deep creek dve |  | doncaster east |  | Western_Australia | 3109 | AUS
100 Murray Street |  | PYRMONT |  | NSW | 2009 | AUS | Prospect | Services | Telecommunications
21 Ross Street |  | [NAME] |  | NSW | 2037 | AUS | Prospect | Hospitality | Hospitality / Leisure
Level 26 Darling Park Tower 1 201 [NAME] |  | Sydney |  | New South Wales | 2000 | AUS | Prospect
26-32 [NAME] |  | Meadowbrook |  | QLD | 4131 | AUS | Prospect | Manufacturing | Food, Beverages and Tobacco
74-76 Redfern Street |  | Wetherill Park |  | NSW | 2164 | AUS | Customer | Manufacturing | Food, Beverages and Tobacco
74-76 Redfern Street |  | Wetherill Park |  | NSW | 2164 | AUS | Customer | Manufacturing | Food, Beverages and Tobacco
74-76 Redfern Street |  | Wetherill Park |  | NSW | 2164 | AUS | Customer | Manufacturing | Food, Beverages and Tobacco
74-76 Redfern Street |  | Wetherill Park |  | NSW | 2164 | AUS | Customer | Manufacturing | Food, Beverages and Tobacco
74-76 Redfern Street |  | Wetherill Park |  | NSW | 2164 | AUS | Customer | Manufacturing | Food, Beverages and Tobacco
1 Hume Rd |  | [NAME] |  | Victoria | 3026 | AUS | Customer | Healthcare
 |  |  |  |  |  | AUS | Customer
Level 20, Gold Fields House 1 Alfred Street Circular Quay PO box R1406, Royal Exchange 1225 |  | SYDNEY |  | NSW | 6017 | AUS | Customer | Manufacturing | Manufacturing
Level 20, Gold Fields House 1 Alfred Street Circular Quay PO box R1406, Royal Exchange 1225 |  | SYDNEY |  | NSW | 6017 | AUS | Customer | Manufacturing | Manufacturing
 |  |  |  | Western Australia |  | AUS | Customer | Manufacturing | Manufacturing
Level 20, Gold Fields House 1 Alfred Street Circular Quay PO box R1406, Royal Exchange 1225 |  | SYDNEY |  | NSW | 6017 | AUS | Customer | Manufacturing | Manufacturing
 |  |  |  |  |  | AUS | Customer | Manufacturing | Manufacturing
 |  |  |  | QLD |  | AUS | Customer | Manufacturing | Manufacturing
26 Auburn Road |  | Regents Park |  | New South Wales |  | AUS | Customer | Manufacturing | Manufacturing
26 Auburn Road |  | Regents Park |  | New South Wales |  | AUS | Customer | Manufacturing | Manufacturing
 |  |  |  |  |  | AUS | Customer | Manufacturing | Manufacturing
Level 20, Gold Fields House 1 Alfred Street Circular Quay | PO box R1406, Royal Exchange 1225 | Sydney |  | New South Wales | 6017 | AUS | Customer | Manufacturing | Manufacturing
Level 20, Gold Fields House 1 Alfred Street Circular Quay | PO box R1406, Royal Exchange 1225 | Sydney |  | New South Wales | 2000 | AUS | Customer | Manufacturing | Manufacturing
26 Auburn Road |  | Regents Park |  | New South Wales |  | AUS | Customer | Manufacturing | Manufacturing
 |  |  |  | Western Australia |  | AUS | Customer | Manufacturing | Manufacturing
429 Scarborough Beach Road |  | OSBORNE PARK |  | WA | 6017 | AUS | Customer | Manufacturing | Manufacturing
26 Auburn Road |  | REGENTS PARK |  | NSW | 2143 | AUS | Customer | Manufacturing | Manufacturing
 |  |  |  | Western Australia |  | AUS | Customer | Manufacturing | Manufacturing
26 Auburn Road |  | Regents Park |  | New South Wales |  | AUS | Customer | Manufacturing | Manufacturing
 |  |  |  | Western Australia |  | AUS | Customer | Manufacturing | Manufacturing
429 Scarborough Beach |  | Osborne Park |  | Waus |  | AUS | Customer | Manufacturing
 |  |  |  | New South Wales | 2019 | AUS | Prospect | Healthcare
32-34 Lord St |  | Botany |  | New South Wales | 2019 | AUS | Prospect | Healthcare
32-34 Lord St |  | Botany |  | New South Wales | 2019 | AUS | Prospect | Services | Media / Advertising
20-22 Mcpherson St |  | Banksmeadow |  | New South Wales | 2019 | AUS | Prospect | Healthcare
Locked Bag 5016 |  | Botany |  | New South Wales | 1455 | AUS | Prospect | Healthcare
1 ABC Street |  | Melbourne |  | Victoria | 3000 | AUS | Prospect | Services | Media / Advertising
L16, 71 Eagle St |  | Brisbane |  | Queensland | 4000 | AUS | Prospect | Services | Media / Advertising
2900 MCCANN RD 103 |  | LONGVIEW |  | New_South_Wales | 75605 | AUS | Prospect | Services | Media / Advertising
ABC Ultimo Centre | 700 Harris Street | [NAME] |  | NSW | 2007 | AUS | Prospect | Services | Media / Advertising
ABC Ultimo Centre | 700 Harris Street | [NAME] |  | NSW | 2007 | AUS | Prospect | Services | Media / Advertising
ABC Ultimo Centre | 700 Harris Street | [NAME] |  | NSW | 2007 | AUS | Prospect | Services | Media / Advertising
L16, 71 Eagle St |  | Brisbane |  | Queensland |  | AUS | Prospect | Services | Media / Advertising
ABC Ultimo Centre | 700 Harris Street | [NAME] |  | NSW | 2007 | AUS | Prospect | Services | Media / Advertising
ABC Ultimo Centre | 700 Harris Street | [NAME] |  | NSW | 2007 | AUS | Prospect | Services | Media / Advertising