Can I convert a WORD document to EXCEL?

R

Robert Judge

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.
 
J

jeff

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
 
A

AlfD

Hi!

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

Data> Text to Columns gives you a lot of power and considerabl
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 t
being stripped off. (eg Is there a space after the first name? las
name?) You can keep running Text to Columns for as long as you hav
usable delimiters (commas, spaces etc).

In the end, you might have to do a bit of manual labour too: but yo
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.

Al
 
U

unlikeKansas

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
 
U

unlikeKansas

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.
 
Top