Text to Columns

[Craig]

I have a list of the Fortune 1000 companies in one cell.
Is there a way to convert this information into columns
with:

Company City State Telephone

1 Wal-Mart Stores, Inc. Bentonville, AR 479-273-4000
2 Exxon Mobil Corporation Irving, TX 972-444-1000
3 General Motors Corporation Detroit, MI 313-556-5000
4 Ford Motor Company Dearborn, MI 800-392-3673
5 General Electric Company Fairfield, CT 203-373-2211
6 ChevronTexaco Corporation San Ramon, CA 925-842-1000
7 ConocoPhillips Houston, TX 281-293-1000
8 Citigroup Inc New York, NY 212-559-1000
9 International Business Machines Corporation Armonk, NY
914-499-1900
10 American International Group New York, NY 212-770-7000
11 Hewlett-Packard Company Palo Alto, CA 650-857-1501
12 Verizon Communications New York, NY 212-395-2121
13 Home Depot, Inc. Atlanta, GA 770-433-8211
14 Berkshire Hathaway Omaha, NE 402-346-1400
15 Altria Group, Inc. New York, NY 917-663-5000
16 McKesson Corporation San Francisco, CA 415-983-8300
17 Cardinal Health, Inc Dublin, OH 614-757-5000
18 State Farm Insurance Bloomington, IL 1-877-734-2265
19 The Kroger Co Cincinnati, OH 513-762-4000
20 Fannie Mae Washington, DC 202-752-7000

 

[Frank Kabel]

Hi
looking at your data this is not completely possible. e.g.
- city names consisting of more than one word
- comas in the company name

So you'll have to do at least some things manually. as a starting point
I would try to use multiple 'Data - text to columns' processes (e.g.
first using the coma as delimiter and afterwards the space character)