How to convert a huge table in MS word to MS excel

R

Rum

Hi,

I have a huge table in MS word. It has 10 columns and over 2000 rows. I wish
to convert this to excel. How to do this without loosing the integrity of the
data.

I tried to do copy an dpaste but then my table looses its integrity. Some
times 2 or more cells (in excel) appear to contain what was contained in 1
cell in word.

Kindly help.

Thanks
Rum
 
P

Pamelia Caswell via OfficeKB.com

It the Word table cells contain tabs, line breaks, or returns, they ( the
tabs, etc.) can cause two or more cells in Excel. I transfer tables from
Word to Excel (and the other way) fairly often but not often enough to
figure out why the behavior changes. So I'll just suggest that you try
regular paste and paste special, unformatted text. One or the other often
works. For more complex large tables, I have copied and then proofed, a
section at a time.

Pam
 

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

Arabic ligatures In MS Word 2019 1
To make pdf to work as word 1
How to use/create code in MS Word to calculate age? 0
Paste to excel from word - auto format problem 1
How to make the shading look uniform around a double spaced line in MS Word? 0
ISO best steps to export (import) all from Outlook 2003 to Outlook in MS 365 0
Excel --> Word 4
Open my default template when right click, select New MS Word doc within a folder 0

Top