Word text into Excel format

[Louise]

I have a word document that contains a simple table,
consisting of one column. each row contains a number and
a description at the side. However, as the details are
in one row, I want to export it into Excel but put the
number in the first column and the description in the
next column, so I can then sort it by column B.

I can't think of an easy way to do this.

can anybody offer any urgent help?

Thanks.

Louise

 

[Andy Brown]

I want to export it into Excel but put the

number in the first column and the description in the
next column, so I can then sort it by column B.

Is it an actual table? Won't it copy & paste into separate columns? Check
out (copy &) paste special -- text, followed by Data -- Text to columns.

Or (nifty) you can select columns in Word by dragging while holding down
ALT.

HTH,
Andy

 

[Louise]

yes it is an actual table, however, the table only
consists of one column and hundreds of rows, so when i
copy and paste, it pastes into one column in Excel. I
want to split the data into three columns. Any idea???

Thanks
Louise

 

[Andy Brown]

yes it is an actual table, however, the table only

consists of one column and hundreds of rows, so when i
copy and paste, it pastes into one column in Excel. I
want to split the data into three columns. Any idea???

Yes. Use the ALT method in Word to copy over "pseudo-columns" individually.
Or copy it all over then use "Text to columns" in Excel.

???,
Andy

 

[Louise]

sorry to make this so confusing. when you say use the
ALT method?? By doing what?

Also, I've tried the text to columns but because i can
only use the 'space' option as the separator, it puts
every single word in a column of its own, whereas i only
want 3 columns.

any more ideas?? would it help if i sent you a sample of
the worksheet?

thanks again.

Louise

 

[Andy Brown]

sorry to make this so confusing. when you say use the

ALT method?? By doing what?

Hold down the ALT key ; then click & drag column-wise in your doc.

Also, I've tried the text to columns but because i can
only use the 'space' option as the separator, it puts
every single word in a column of its own, whereas i only
want 3 columns.

Use the Fixed Width option.

Rgds,
Andy