Spreadsheet: 141432d1329260068-creating-a-list-using-data-validation-can-i-create-a-subcategory-list-sonepar-technology-team-pos-and-invoices-2012
Sheet: Cooper Branches

COOPER ELECTRIC BRANCHES
SONEPAR USA
February 2010
[NAME]
# | COMPANY | OPCO | BRANCH | DEPT | CLASS | NAME | STREET ADDRESS | CITY | State | ZIP CODE | PHONE | City & Branch ID
1 | [NAME] | CCOR | CAUG | CAUG | BRANCH | COOPER ELECTRIC SUPPLY CO | 17 ROUTE 206 SOUTH UNIT 3 | AUGUSTA | NJ | 07822 | [PHONE]
 | [NAME] | CCOR | CBER | CBER | BRANCH | COOPER ELECTRIC SUPPLY CO | 72 NORTH WASHINGTON AVENUE | BERGENFIELD | NJ | 07621-1700 | [PHONE]
 | [NAME] | CCOR | CBET | CBET | BRANCH | COOPER ELECTRIC SUPPLY CO | 945 BETHLEHEM DRIVE | BETHLEHEM | PA | 18017-7021 | [PHONE]
 | [NAME] | CCOR | CBET | CDBE | DEPT | COOPER ELECTRIC SUPPLY CO | 945 BETHLEHEM DRIVE, CROSSDOCK WH | BETHLEHEM (CD WH) | PA | 18017-7021 | [PHONE]
 | [NAME] | CCOR | CBRI | CBRI | BRANCH | COOPER ELECTRIC SUPPLY CO | 933 CEDARBRIDGE AVENUE | BRICK | NJ | 08723-4111 | [PHONE]
 | [NAME] | CCOR | CBRI | CGCE | DEPT | COOPER ELECTRIC SUPPLY CO | 933 CEDARBRIDGE AVENUE, GEAR | BRICK - Gear | NJ | 08723-4111 | [PHONE]
 | [NAME] | CCOR | CDBK | CDBK | BRANCH | LEVITAN ROBBINS INC | 10300 FOSTER AVE, CROSSDOCK WH | BROOKLYN (CDC WH) | NY | 11236-2206 | [PHONE]
 | [NAME] | CCOR | CEGG | CEGG | BRANCH | COOPER ELECTRIC SUPPLY CO | 2727 FIRE ROAD | EGG HARBOR TWP | NJ | 08234-9539 | [PHONE]
 | [NAME] | CCOR | CELM | CELM | BRANCH | COOPER ELECTRIC SUPPLY CO | 100 GRASSLANDS ROAD | ELMSFORD | NY | 10523-1110 | [PHONE]
 | [NAME] | CCOR | CELM | CGHV | DEPT | COOPER ELECTRIC SUPPLY CO | 100 GRASSLANDS ROAD, [NAME] | ELMSFORD (Gear) | NY | 10523-1110 | [PHONE]
 | [NAME] | CCOR | CELM | CLHV | DEPT | COOPER ELECTRIC SUPPLY CO | 100 GRASSLANDS ROAD, HUDSON VALLEY LIGHTING | ELMSFORD (Lighting) | NY | 10523-1110 | [PHONE]
 | [NAME] | CCOR | CFAI | CFAI | BRANCH | COOPER ELECTRIC SUPPLY CO | 444 ROUTE 46 | FAIRFIELD | NJ | 07004 | [PHONE]
 | [NAME] | CCOR | CFAI | CGNO | DEPT | COOPER ELECTRIC SUPPLY CO | 444 ROUTE 46, GEAR | FAIRFIELD (Gear) | NJ | 07004 | [PHONE]
 | [NAME] | CCOR | CFVW | CFVW | BRANCH | COOPER ELECTRIC SUPPLY CO | 217 BROAD AVE | FAIRVIEW | NJ | 07022-1095 | [PHONE]
 | [NAME] | CCOR | CFLE | CFLE | BRANCH | COOPER ELECTRIC SUPPLY CO | 19 ROYAL ROAD | FLEMINGTON | NJ | 08822-6001 | [PHONE]
 | [NAME] | CCOR | CFRE | CFRE | BRANCH | COOPER ELECTRIC SUPPLY CO | 3477 ROUTE 9 NORTH | FREEHOLD | NJ | 07728 | [PHONE]
 | [NAME] | CCOR | CGAR | CGAR | BRANCH | COOPER ELECTRIC SUPPLY CO | 2200 JERICHO TURNPIKE ROUTE 25 | GARDEN CITY PARK | NY | 11040 | [PHONE]
 | [NAME] | CCOR | CGAR | CNYC | DEPT | LEVITAN ROBBINS | 2200 JERICHO TURNPIKE ROUTE 25 | GARDEN CITY PARK (Levitan) | NY | 11040 | [PHONE]
 | [NAME] | CCOR | CHAM | CHAM | BRANCH | COOPER ELECTRIC SUPPLY CO | 300 CLOCKTOWER DRIVE, SUITE 201 | HAMILTON | NJ | 08691 | [PHONE]
 | [NAME] | CCOR | CJER | CJER | BRANCH | COOPER ELECTRIC SUPPLY CO | 1521 KENNEDY BLVD | JERSEY CITY | NJ | 07097 | [PHONE]
 | [NAME] | CCOR | CLIN | CLIN | BRANCH | COOPER ELECTRIC SUPPLY CO | 1805 LOWER ROAD | LINDEN (Branch) | NJ | 07036-6590 | [PHONE]
 | [NAME] | CCOR | CDLN | CDLN | BRANCH | COOPER ELECTRIC SUPPLY | 1805 LOWER ROAD, CROSSDOCK WH | LINDEN (CDC WH) | NJ | 07036-6590 | [PHONE]
 | [NAME] | CCOR | CMAN | CMAN | BRANCH | COOPER ELECTRIC SUPPLY CO | 317 EAST BAY AVENUE | MANAHAWKIN | NJ | 08050-3320 | [PHONE]
 | [NAME] | CCOR | CMID | CMID | BRANCH | COOPER ELECTRIC SUPPLY CO | 666 HIGHWAY 35 | MIDDLETOWN | NJ | 07748 | [PHONE]
 | [NAME] | CCOR | CMID | CHDW | DEPT | COOPER ELECTRIC SUPPLY CO | 666 HIGHWAY 35, HARDWARE | MIDDLETOWN (HW) | NJ | 07748 | [PHONE]
 | [NAME] | CCOR | CMOR | CMOR | BRANCH | COOPER ELECTRIC SUPPLY CO | 168 RIDEGDALE AVENUE | MORRISTOWN | NJ | 07962 | [PHONE]
 | [NAME] | CCOR | CLNY | CDAT | DEPT | COOPER ELECTRIC SUPPLY CO | 43 W 24TH ST FL 4, DATACOMM | NEW YORK (Datacomm) | NY | 10010-3518 | [PHONE]
 | [NAME] | CCOR | CLNY | CGNY | DEPT | COOPER ELECTRIC SUPPLY CO | 43 WEST 24TH STREET 4TH FLOOR, GEAR | NEW YORK (Gear) | NY | 10010 | [PHONE]
 | [NAME] | CCOR | CLNY | CLNY | BRANCH | COOPER ELECTRIC SUPPLY CO | 43 WEST 24TH STREET 4TH FLOOR, COMMERCIAL LIGHTING | NEW YORK (Lighting) | NY | 10010 | [PHONE]
 | [NAME] | CCOR | CPNY | CPNY | BRANCH | COOPER ELECTRIC SUPPLY CO | 43 W 24TH ST FL 4, POWER | NEW YORK (Power) | NY | 10010-3518 | [PHONE]
 | [NAME] | CCOR | CNEW | CNEW | BRANCH | COOPER ELECTRIC SUPPLY CO | 38 SOUTH PLANK ROAD | NEWBURGH | NY | 12550-3927 | [PHONE]
 | [NAME] | CCOR | COCN | COCN | BRANCH | COOPER ELECTRIC SUPPLY CO | 42 CINDY LANE | OCEAN | NJ | 07712 | [PHONE]
 | [NAME] | CCOR | CPAD | CPAD | BRANCH | COOPER ELECTRIC SUPPLY CO | 42 CINDY LANE | OCEAN (Power Admin) | NJ | 07712 | [PHONE]
 | [NAME] | CCOR | CPHI | CPHI | BRANCH | COOPER ELECTRIC SUPPLY CO | 224 STOCKTON STREET | PHILLIPSBURG | NJ | 08865-2994 | [PHONE]
 | [NAME] | CCOR | CPLA | CPLA | BRANCH | COOPER ELECTRIC SUPPLY CO | 412 WEST SECOND STREET | PLAINFIELD | NJ | 07061 | [PHONE]
 | [NAME] | CCOR | CSWA | CSWA | BRANCH | COOPER ELECTRIC SUPPLY CO | 639 S CHESTER RD | SWARTHMORE | PA | 19081-2315 | [PHONE]
 | [NAME] | CCOR | CCOR | CCOR | BRANCH | COOPER ELECTRIC SUPPLY CO | 70 APPLE ST | [NAME] (Corporate) | NJ | 07724-2600 | [PHONE]
 | [NAME] | CCOR | CWB | CWB | BRANCH | COOPER ELECTRIC SUPPLY CO | 402 BLOOMFIELD AVENUE | WEST BERLIN | NJ | 08091 | [PHONE]
 | [NAME] | CCOR | CWB | CPSO | DEPT | COOPER ELECTRIC SUPPLY CO | 402 BLOOMFIELD AVENUE | WEST BERLIN (South) | NJ | 08091 | [PHONE]
 | [NAME] | CCOR | CNAT | CNAT | BRANCH | COOPER ELECTRIC SUPPLY CO | 1251 METROPOLITAN AVENUE | WEST DEPTFORD | NJ | 08086 | [PHONE]
 | [NAME] | CCOR | CNAT | CDWD | DEPT | COOPER ELECTRIC SUPPLY CO | 1251 METROPOLITAN AVENUE, CROSSDOCK WH | WEST DEPTFORD (CDC WH) | NJ | 08086 | [PHONE]
 | [NAME] | CCOR | CNAT | CGSO | DEPT | COOPER ELECTRIC SUPPLY CO | 1251 METROPOLITAN AVENUE, GEAR | WEST DEPTFORD (Gear) | NJ | 08086 | [PHONE]
 | [NAME] | CCOR | CNAT | CLWD | DEPT | COOPER ELECTRIC SUPPLY CO | 1251 METROPOLITAN AVENUE, COMMERCIAL LIGHTING | WEST DEPTFORD (Lighting) | NJ | 08086 | [PHONE]