separating data in cells

C

cw

I have a very long excel spreadsheet with data like this in each cell:
Alaska Native Medical Center
4315 Diplomacy Drive
Anchorage,  AK  99508 Phone: (907) 563-2662
Medicare provider code: 020026
Number of beds: 140

Is there any way to break up this data into columns, such as "name,
address, phone, etc etc?

    The purpose of this is to import all the information into an
address book or act. Any help would be appreciated.
~Chris
 
J

Jim Cone

Chris,

No help from here yet, but...
Are the entire five lines that you posted in one cell?
or
Are the five lines in separate rows?

Are they all in one column?
Approximately, now many are you talking about?

Regards,
Jim Cone
San Francisco, CA
 
D

Dave Peterson

If you used alt-enters to force new lines...
you could select your range (one column at a time)
data|text to columns|delimited
hit alt-0010 (use the number keypad--not the numbers above the QWERTY keys)
in the Other box

Leave enough room to the right (or hit edit|undo!)
 
J

Jim Cone

Dave,

Your solution is a lot easier than I want I had in mind.

Regards,
Jim Cone
San Francisco, CA

Dave Peterson said:
If you used alt-enters to force new lines...
you could select your range (one column at a time)
data|text to columns|delimited
hit alt-0010 (use the number keypad--not the numbers above the QWERTY keys)
in the Other box

Leave enough room to the right (or hit edit|undo!)
Click to expand...
- snip -
 
D

Dave Peterson

But only if the lines were really split with alt-enters.

(and by the length of each line, it might have been!)
 
Top