Word text into Excel format

  • Thread starter Thread starter Louise
  • Start date Start date
L

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
 
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.
Click to expand...

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
 
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
 
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???
Click to expand...

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
 
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
 
sorry to make this so confusing. when you say use the
ALT method?? By doing what?
Click to expand...

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.
Click to expand...

Use the Fixed Width option.

Rgds,
Andy
 
Back
Top