----------
> From: Mick Fitzpatrick <[log in to unmask]>
> Subject: [PCSOFT] Word List to Excel
> Date: Monday, August 24, 1998 3:25 PM
>
> 15121 AL WILSON The snake / Who could be loving you 15
>
> Is it possible to easily transfer this type of info to Excel so that each
> section will sit in it's own cell on a row in the spreadsheet?
>
When the data is pretty much free-form like you have it above, this is not
an easy thing to do. However, you can convert the data into a table in
Word and, once that is done, you can select all all the rows and columns of
the table, copy them and paste them directly into a block of Excel cells of
the same size. The other thing you could do is to insert a character to
separate the data into the different items or make the columns fixed sizes
and then save the file as a text file that can be imported into Excel by
opening the text file as either a delimited or fixed-field file.
|