Here is an example, that is also based on the template I gotta parse.
I need only part of this data.



0593
L&P Chicago Heights Chicago Heights IL 60411




Leggett & Platt Inc

D-U-N-S® Number: 13-368-8262
Company Name: Leggett & Platt Inc
Also Known As: Morgan Marshall

Mail Address: 383 E 16th St
Chicago Heights, IL, 60411-3701
View Map

County: Cook
MSA: Chicago

Phone: 708-758-6300
Fax: 708-758-5858
WebAddress: www.leggett.com

Location Type: Branch
Plant/Facility Size: 205,000 Sq Ft
Foreign Trade: Import/Export
Year Established: 1989
Ownership: Public
Prescreen Sco Low Risk
Stock Ticker: LEG

Global Ultimate Parent: Leggett & Platt Inc
1 Leggett Rd
Carthage, MO, 64836-9649
417-358-8131
View Global Ultimate Profile





Employee Count:
(All Sites) 33,000
Employment:
(Individual Site) Current Year: 550
1 Yr Prior: 200 | Trend: 175.00
2 Yr Prior: 200 | Trend: 175.00
3 Yr Prior: 550 | Trend: 0.00
Sales:
(All Sites) $5,085,500,000
US (Actual)
Sales:
(Individual Sites) $58,428,150
US (Estimated/Modeled)



Executives: Mr Phillip A Rosenband - President
Mr Phillip A Rosenband - Owner
Mr Jeff Blau - Purchasing Director
Mr Stanley R Jewell - Chief Financial Officer
Mr Stanley R Jewell - Treasurer

Add Decision Maker

Sic Code(s): 25410203 - Shelving, office and store, wood (Primary)
25429904 - Shelving, office and store, except wood
Line of Business: Manufactures wooden & metal store fixtures
Product(s): STORE & DISPLAY FIXTURES & EQPT: Wood
STORE & DISPLAY FIXTURES & EQPT, EXC WOOD
Naics Code(s): 337215 - Showcase, Partition, Shelving & Locker Mfg
(Primary)


--
BBFB
------------------------------------------------------------------------
BBFB's Profile: http://www.excelforum.com/member.php...o&userid=26344
View this thread: http://www.excelforum.com/showthread...hreadid=396092