Can I convert a WORD document to EXCEL?

A person has a data base program of some kind that tracks
students in a school. I have asked her to save the file
in a CSV format and send it to me so that I can import
the file into EXCEL for my use.

She says that the program does not give her the option to
save her data in a CSV format. She has sent it to me in
a TEXT format and in a WORD format. However, I can't get
either of these formats to import nicely into EXCEL.
What I get is one big column that includes all the data,
not the seperate columns of name and address that I
want. Naturally, I don't want to have to type the 200
names and address again.

If she can't give the file to me in a CSV format, but
only in a TEXT or WORD format, how can I export what she
gives me into EXCEL in a way that will create columns
that include names in one column and address in another
column? I will appreciate advice.

Hi

If you can just get it into a format that is consistent,
i.e., fields (columns) are separated by tabs or perhaps
even spacing (Last name always starts at position 40),
then you could import it in.

Any way of doing that?

jeff
-----Original Message-----
A person has a data base program of some kind that
tracks
students in a school. I have asked her to save the file
in a CSV format and send it to me so that I can import
the file into EXCEL for my use.

She says that the program does not give her the option
to
save her data in a CSV format. She has sent it to me in
a TEXT format and in a WORD format. However, I can't
get
either of these formats to import nicely into EXCEL.
What I get is one big column that includes all the data,
not the seperate columns of name and address that I
want. Naturally, I don't want to have to type the 200
names and address again.

If she can't give the file to me in a CSV format, but
only in a TEXT or WORD format, how can I export what she
gives me into EXCEL in a way that will create columns
that include names in one column and address in another
column? I will appreciate advice.
.

Hi!

When you have imported the text into Excel, try a bit of
experimentation.

Data Text to Columns gives you a lot of power and considerable
flexibility. But don't expect it to separate all the bits at one pass.

Run the routine: observe if any parts of the data lend themselves to
being stripped off. (eg Is there a space after the first name? last
name?) You can keep running Text to Columns for as long as you have
usable delimiters (commas, spaces etc).

In the end, you might have to do a bit of manual labour too: but you
may be able to avoid quite a lot.

If you post say three lines of what comes over on the data transfer,
someone may have an insight.

Alf


---
Message posted from http://www.ExcelForum.com/

Do the work in Word first.

Replace all relevant spaces (ie where you want the field breaks) in the document with commas or some other identifiable character. Save it as a text only file and then open that in excel. Excel will then assist you with the Text Import Wizard

"AlfD " wrote:

Hi!

When you have imported the text into Excel, try a bit of
experimentation.

Data Text to Columns gives you a lot of power and considerable
flexibility. But don't expect it to separate all the bits at one pass.

Run the routine: observe if any parts of the data lend themselves to
being stripped off. (eg Is there a space after the first name? last
name?) You can keep running Text to Columns for as long as you have
usable delimiters (commas, spaces etc).

In the end, you might have to do a bit of manual labour too: but you
may be able to avoid quite a lot.

If you post say three lines of what comes over on the data transfer,
someone may have an insight.

Alf


---
Message posted from http://www.ExcelForum.com/

Do the work in Word first. Globally replace all spaces with an identifiable character (e.g. comma). Then save the Word file as text only.

Open the Text file in Excel and the Text Import Wizard will help you through the rest.

"Robert Judge" wrote:

A person has a data base program of some kind that tracks
students in a school. I have asked her to save the file
in a CSV format and send it to me so that I can import
the file into EXCEL for my use.

She says that the program does not give her the option to
save her data in a CSV format. She has sent it to me in
a TEXT format and in a WORD format. However, I can't get
either of these formats to import nicely into EXCEL.
What I get is one big column that includes all the data,
not the seperate columns of name and address that I
want. Naturally, I don't want to have to type the 200
names and address again.

If she can't give the file to me in a CSV format, but
only in a TEXT or WORD format, how can I export what she
gives me into EXCEL in a way that will create columns
that include names in one column and address in another
column? I will appreciate advice.