Copy a table from Word to Excel
klopatios
-
louise -
louise -
Hello,
I have a Word file with a table that contains 1 column and 200 rows (only text, no numbers). I want to copy it into Excel while keeping the same format. However, when I do a simple copy/paste, it creates multiple rows (about 1300).
Thank you!
Configuration: Windows 7 / Chrome 22.0.1229.79
I have a Word file with a table that contains 1 column and 200 rows (only text, no numbers). I want to copy it into Excel while keeping the same format. However, when I do a simple copy/paste, it creates multiple rows (about 1300).
Thank you!
Configuration: Windows 7 / Chrome 22.0.1229.79
7 answers
Hello,
The issue can be circumvented and there is probably a solution;
When a table is copied and pasted with a simple paste, line breaks are treated as end of cells. You just need to get rid of them in Word and put them back in Excel.
Following a process according to the steps below should do the trick:
- Copy the table and only the table into a new Word document to make the next steps easier.
- Replace all paragraph-type line breaks with a unique special character. For example: Edit > Replace "^p" with "<12>". In Word, ^p means the paragraph-type line break and the replacement character can be anything that does not appear in the text.
- Copy everything into Excel. Now, each cell contains multiple lines separated by the separator that replaces the line breaks (<12> in my case).
- Now in Excel, just replace "<12>" with a line break. To do this: Edit > Replace "<12>" with "alt+32". (In fact, alt+32 makes the line break appear as a space).
- Click on replace all to finish.
That's what I would have done. I tested it at home. I have Office 2000 version for your information.
--
C. Taha
The issue can be circumvented and there is probably a solution;
When a table is copied and pasted with a simple paste, line breaks are treated as end of cells. You just need to get rid of them in Word and put them back in Excel.
Following a process according to the steps below should do the trick:
- Copy the table and only the table into a new Word document to make the next steps easier.
- Replace all paragraph-type line breaks with a unique special character. For example: Edit > Replace "^p" with "<12>". In Word, ^p means the paragraph-type line break and the replacement character can be anything that does not appear in the text.
- Copy everything into Excel. Now, each cell contains multiple lines separated by the separator that replaces the line breaks (<12> in my case).
- Now in Excel, just replace "<12>" with a line break. To do this: Edit > Replace "<12>" with "alt+32". (In fact, alt+32 makes the line break appear as a space).
- Click on replace all to finish.
That's what I would have done. I tested it at home. I have Office 2000 version for your information.
--
C. Taha
The alt 32 and alt 10 don't work for me :(