Share via

Converting Word to Excel

Anonymous
2010-11-25T14:51:26+00:00

I have a Word document with tables which I want to convert to Excel. I wasn't sure how to even start to convert so I decided to copy and paste the cells in the Word table to the cells in Excel.

What I find is happening is that if there are 2 or more lines in the Word cell when I try to copy multiple cells those lines are pasting on the next row down in Excel. I can get around this by copying the document cell by cell and pasting the content directly in the cell bar instead of the cell itself.

Is there any way to copy more than one cell from a Word table and paste it so that  the 'enter' command in Word is translated to Alt Enter (new line) in Excel? Or is there any other way to do this?

Thanks

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2010-11-25T15:37:23+00:00
    1. In Word, first convert all embedded hard returns into another "special character"
    2. Copy Table from Word and paste in Excel
    3. In Excel, convert the "special character" back into a hard return

    gsnu201005

    Was this answer helpful?

    5 people found this answer helpful.
    0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2010-11-25T15:17:08+00:00

    First copy the table cell in Word.  Then in Excel click on a cell and then click in the formula bar  and then CNTRL-v

    gsnu201005

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2012-02-02T11:12:33+00:00

    Thanks for the feedback!

    Was this answer helpful?

    0 comments
  3. Anonymous
    2012-02-02T08:15:14+00:00

    First copy the table cell in Word.  Then in Excel click on a cell and then click in the formula bar  and then CNTRL-v

    gsnu201005

    worked perfect for me. thank you very much

    Was this answer helpful?

    0 comments
  4. Anonymous
    2010-11-25T15:26:40+00:00

    Thank you gsnu201005 and yes that is my 'get around' but the document is 28 pages long and I want to be able to copy multiple cells instead of cell by cell

    Thanx

    Was this answer helpful?

    0 comments