Word table into Excel Worksheet

[sopranoiam]

I have a 100+ page Word table that I want to put into an Excel worksheet. Is there a macro or an easy way to do this and have a coherent Excel worksheet when I finish? I end up with so many blank rows and the text is all over. I didn't create the Word doc so formatting is unruly.

Thanks, Gay

 

[radas]

Does anyone know how to copy the table without losing any formatting. When I use above macro, I can copy all cell data but I am loosing format (Like bullet points, page breaks and paragraph breaks). Anyone have modified code to NOT to lose any formatting? TIA.

 

[oldbrewer]

would you want the bullet point and its associated text in one cell, or the bullet in one cell the text in another

it may help if you explain why you need to do this as WORD is for words and EXCEL is for calculations [broad simplification]

 

[radas]

Thank you for quick response.

My word table has Text with bullet points.

Ex:
This is a text paragraph

• Text 1
• Text 2
• Text 3

I want everything in one cell without losing formatting.

would you want the bullet point and its associated text in one cell, or the bullet in one cell the text in another

it may help if you explain why you need to do this as WORD is for words and EXCEL is for calculations [broad simplification]

 

[oldbrewer]

a word table is quite similar to a block of excel cells

what are you going to do with it all when it is in excel

(this will help people to help you)

 

[radas]

I am trying to copy about 100 tables of requirements from word doc to Excel. With above code I can copy those requirements to excel, but I am losing the formatting (Not all columns, in word, have formatting)

a word table is quite similar to a block of excel cells

what are you going to do with it all when it is in excel

(this will help people to help you)

 

[oldbrewer]

I repeat - what is the driving requirement to copy the tables into Excel ?

 

[radas]

I want to use excel for my estimates and play with numbers for each requirement.
Hope that helps to understand why I want to copy from doc to excel

I repeat - what is the driving requirement to copy the tables into Excel ?

 

[oldbrewer]

ok - if one "cell" of word table contains apples $3.50 per kilo
it will not be straightforward to get at the $3.50

can we see a few rows of a typical word table
(highlight it, edit copy, and paste into the reply box here)

 

[TrailRunner]

ok - if one "cell" of word table contains apples $3.50 per kilo
it will not be straightforward to get at the $3.50

can we see a few rows of a typical word table
(highlight it, edit copy, and paste into the reply box here)

Hi - I am new to this forum and have found it very helpful. I am following up on this thread as I have a similar challenge. I am importing tables from a word doc to excel (requirements in a BRD) in order to bulk upload them into HP ALM. The table has 3 columns - ID, Function, Description. The description may have text formatting and .jpg/.png that I would like to retain. Can you offer assistance with this?