copy to excel / urgent

[pic]

Hello, i have this docoment in word in which i have 4 columns
(actually these are not real columns like those in excel, they are separated
using spaces between them).
I need to import this to excel so every column is in its own table, but i
can't select every column with mouse.

Is there a way i could do this, not to type in excel everything?
I hope you understand my problem.
Any help gretly appreciated,
Marko

 

[Mark]

You can highlight the column (or any block of text) by holding down the
'Alt' key while you select the text you want to copy with your mouse. Then
copy and paste it into excel document. Each line of the column selected
will be pasted into a separate cell.

Hope that helps.

Rob

 

[Robin Graham]

The first point to make here is that it is bad practice to make columns
using spaces. You should either set up a table and put the words into each
cell, or align the columns by using tabs. There are several reasons for
this.

1. It makes it simple to do what you are trying to do.

2. You can re-set the column width very easily and globally without having
to put more or less spaces in each individual column.

3. Whe you print the document you may find that, with the way you've done
it, the columns don't always line up nicely. They will if you've used a
table or tabs.

4. The amount of file space taken up is probably less if done properly than
by using spaces.

5. You can convert the text to a table easily, and vice versa.

So - never use spaces for this!

To address your problem, you need to get rid of the spaces and replace them
with tabs. This can be done globally by selecting the spaces using a
selection marquee while holding down the alt key. You have then got to put
the tabs in. Once you've done this you convert the text to a table (you'll
find this in the Table menu) using 'tabs' as the delimiter, and copy and
paste it to Excel.

Come back if this explanation is not good enough.

Rob Graham

 

[Peter Chadbund]

I would suggest that you recreate your list by replacing your "spaces"with a
comma, creating a csv (comma separated variable file, which should export
without problem.

Peter