Word table into Excel Worksheet

sopranoiam

Board Regular
Joined
Oct 16, 2002
Messages
88
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
 
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.
 
Upvote 0

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
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]
 
Upvote 0
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]
 
Upvote 0
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)
 
Upvote 0
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)
 
Upvote 0
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)
 
Upvote 0
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?
 
Upvote 0

Forum statistics

Threads
1,223,098
Messages
6,170,100
Members
452,301
Latest member
QualityAssurance

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top