Can delimited ASCII be separated into Excel 2002 rows instead of .

[Ralph2908]

I have a set of 400 names and email addressed that I am trying to separate
into three colums: last name first name email address. I have pasted the
whole file into one cell and used the "Data Text to colum" command and it
separates the delimited ASCII file into the 3 components BUT across colums in
row 1 AND does not spearate all of them out because there are too many sets
of names and email addresses and too few columns.

What can I do to get the 3 colums of data I need?

 

[Bernard Liengme]

How did you put ALL the file in one cell?
Open the file with File open, in FileOpen dialog set file type to ALL; click
on the ASCII file
Now reach record in the file should be on a separate row
Select the entire column and do Text to Column as before

best wishes

 

[Thaks Bernard - BUT...]

Thanks Bernard BUT I copy this file from the "To" of an email address box
that contained the entire list of addresses. There is no way to wxport from
Outlook Express just those addresses of this one group. The list I copied
has all of the delimited :look" to it. I can copy it and paste the list but
it either goes in one cell or across the columns. If it goes across the
columns - there are not enough columns to accomodate all 400 names and
addresses.

Any idea as to what can be done to separate the first name, last name and
email address from a group of names that look like this separated in typical
ASCII format by the semicolon. Here is one entry looks like:

Taylor, Ralph <[email protected]>; (this one is mine).

 

[David McRitchie]

Hi Ralph,
Don't know what you did but how about starting over,

Address List
File, Export, other, csv

change file extension to .txt
File, Open, supply name of file
delimited option
continue through the options, you can select a column as a throw away.

 

[Ralph2908]

Again - Maybe I have not been clear up to now - there is no export process
for this segment of the address book. Outlook Express does not allow for
exporting part of the whole address book nor does it distinguish which part
of the whole book it is if exporting the wole book. Givewn that problem - I
addressed an email with the group addresses at which point I cut and pasted
the addresses from the email address line to Excel 2002.

What I pasted looks like ASCII format with semicolons and other conistnet
formats. It even acts like delimited ASCII when I tried "text to colums"
within the tools menu. The problem is that there are not enough colums to
accomodate the nearly 1200 entries the separated files produce.

What I need, I think, is a utility that takes the contents of that one cell
and splits it up amoung three colums with each 3 word phrase on a new row. I
was hoping there was some process within Excel 2002 to handle this.

Thanks for your response though - it is appreciated!!

Hi Ralph,
Don't know what you did but how about starting over,

Address List
File, Export, other, csv

change file extension to .txt
File, Open, supply name of file
delimited option
continue through the options, you can select a column as a throw away.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

I have a set of 400 names and email addressed that I am trying to separate
into three colums: last name first name email address. I have pasted the
whole file into one cell and used the "Data Text to colum" command and it
separates the delimited ASCII file into the 3 components BUT across colums in
row 1 AND does not spearate all of them out because there are too many sets
of names and email addresses and too few columns.

What can I do to get the 3 colums of data I need?

 

[David McRitchie]

You certainly can export the entire address book to a .csv file
and I do it all the time,
and you can certainly throw away the rows you do not want.
You export the columns you want to see by checking the
appropriate boxes.

You cannot copy from rows in the address book into Excel.

Select a single row and paste into notepad -- see what you get.
It is a useful feature because you can copy a row, paste it into
an email and send off to show another person what you have for
someone, name, address, phone number, etc.,
to another person -- but it has no use in Excel.

Why do you want to make things difficult for yourself, and the
format is not a delimited file. Not only that but the content changes
completely depending of what have for each individual entry.

Doe, John
E-mail Address(es):
[email protected]
Personal Information:
Address:
WY

Doe, Sandra
E-mail Address(es):
[email protected]
Personal Information:
Address:
555 West Crescent Circle
One Horse WY 88888-1212
Phone: 555-555-5555
Web Page: http://www.example.com/index.htm
Business Information:
Department: Club Member
Web Page: http://www.wunderground.com/cgi-bin/findweather/getForecast?query=88888
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Again - Maybe I have not been clear up to now - there is no export process
for this segment of the address book. Outlook Express does not allow for
exporting part of the whole address book nor does it distinguish which part
of the whole book it is if exporting the wole book. Givewn that problem - I
addressed an email with the group addresses at which point I cut and pasted
the addresses from the email address line to Excel 2002.

What I pasted looks like ASCII format with semicolons and other conistnet
formats. It even acts like delimited ASCII when I tried "text to colums"
within the tools menu. The problem is that there are not enough colums to
accomodate the nearly 1200 entries the separated files produce.

What I need, I think, is a utility that takes the contents of that one cell
and splits it up amoung three colums with each 3 word phrase on a new row. I
was hoping there was some process within Excel 2002 to handle this.

Thanks for your response though - it is appreciated!!

Hi Ralph,
Don't know what you did but how about starting over,

Address List
File, Export, other, csv

change file extension to .txt
File, Open, supply name of file
delimited option
continue through the options, you can select a column as a throw away.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

I have a set of 400 names and email addressed that I am trying to separate
into three colums: last name first name email address. I have pasted the
whole file into one cell and used the "Data Text to colum" command and it
separates the delimited ASCII file into the 3 components BUT across colums in
row 1 AND does not spearate all of them out because there are too many sets
of names and email addresses and too few columns.

What can I do to get the 3 colums of data I need?