How do I copy a word table into excel

  • Thread starter Thread starter KF
  • Start date Start date
K

KF

I'm trying to copy a word table (contains multiple paragraphs) into excel but
excel breaks each Word cell into several rows.

Is there a way to copy a Word table into Excel cell by cell.
 
Make a text box in Excel and paste to this. Excel is not a word processing
app
best wishes
 
Hi,

1. Save your Word document.
2. Select the entire table
3. Press Ctrl+H
4. Click More
5. Open Special and choose Paragraph Mark
6. Click Replace All
7. Click No to checking the rest of the document.
8. Copy the table
9. Move to Excel and Paste.
10. Close the Word document without saving.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying a table from Word 5
Date Format 1
Copy Word table into Excel cell by cell 3
Alt codes 4
In Excel how do I force text into next line before first is full? 8
Array formula copying blanks as zero’s 5
Text in Excel 6
how do I copy several lines of word text into one excel cell? 2

Back
Top