separating data in cells

  • Thread starter Thread starter cw
  • Start date Start date
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
 
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
 
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!)
 
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 -
 
But only if the lines were really split with alt-enters.

(and by the length of each line, it might have been!)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Separating data to put in seperate cells 5
Separating Numerical and Alpha Data in cells 6
separating data within a cell - how? 6
separating address elements in one cell 6
Transfer data from Excel col. A to columns B-E in the same sheet 3
How to separate multi-line data in cell? 2
Can I copy a table from Word into one cell in Excel without losing data? (Office 97) 2
How to prevent Excel to paste data in separate cells 2

Back
Top