Copying word tables of different column width to excel.

K

Kazuki

Hi, I have a huge word document which has so many tables and some text. I
want to convert this document into excel sheet.
Example: In 1 table the first column is "No." which needs as less space to
enter a single digit number, whereas in the next table, the first column has
some other data, that will need space for upto 15 words!!!!
This is when the problem arises. I cannot have the tables one below the
other in excel sheet.. Is there a method to optimise this???
PS. I have nearly 40 tables like this!!!
Thanks!!
 
A

Ardus Petus

Copy each table to a different worksheet, and auto-adjust column width.

HTH
 
K

Kazuki

Hi Ardus Petus, Thanks for your answer, but as I mentioned, I have over 40
tables and if I use different work sheets, it would distort the format of the
docuiment abruptly.
Can some one please help me with this?
 
A

Ardus Petus

You cannot have different column width within one column of a worksheet.

Cell merging makes things even worse.

HTH
 
K

Kazuki

Hi AP, Thanks again. But actually I wanted to know whether there is any other
method to replace these tables.... and not to have different column widths
with 1 column.
Thanks.
 
Top