How do I copy a word table into excel

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.
 
B

Bernard Liengme

Make a text box in Excel and paste to this. Excel is not a word processing
app
best wishes
 
S

Shane Devenshire

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

Copy Word table into Excel cell by cell 3
Copying a table from Word 5
Alt codes 4
how do I copy several lines of word text into one excel cell? 2
Copy text from word with returns into one cell 8
Excel Data pastes into 2 cells not 1 1
In Excel how do I force text into next line before first is full? 8
Macro to copy text between two different delimeters 1

Top