Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / June 2005

Tip: Looking for answers? Try searching our database.

transferring word doc to excel including table format

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
hokieguy - 10 Jun 2005 15:59 GMT
Any tips on performing this?  Im having great difficulty in having th
table column and row sizes transfer from word to excel.  It stretche
the table out into an unusable format.

Thanks

Justi
bengaluru - 10 Jun 2005 22:16 GMT
No I dont think you can do that
Dave Peterson - 10 Jun 2005 23:09 GMT
What does stretches out mean?

Is it just a formatting thing?  Maybe you can change the font (or font size) and
be back to normal.

Does that mean that some of the cells in the MSWord table have newlines in them
and when they get copied to excel, those individual lines within the cell get
pasted into their own cells?

Saved from a previous post:

If your cells in your word table contain paragraph mark or linebreak characters,
then excel will bring them over as separate cells.

One way around it is to convert those paragraph marks & linebreaks to unique
characters, then copy|paste and then convert them back to linefeeds.

I like this technique (inside a copy of the word file):
Select your table.
Edit|replace|Special (show More if required)
Find what: (paragraph mark under Special button)
replace with:  $$$$$     (if $$$$$ doesn't appear in the table)
replace all

Same thing with Manual Line break (from under Special).

Now copy the table into Excel.

Edit|Replace
Replace what: $$$$$
Replace with: hit and hold the alt and type 0010 from the number pad--not above
QWERTY.

It may look like you haven't done anything, but if you did it right, you
replaced $$$$$ with alt-enter.
Replace all.

Don't forget to close the word document without saving (or hit undo as many
times as necessary).

> Any tips on performing this?  Im having great difficulty in having the
> table column and row sizes transfer from word to excel.  It stretches
[quoted text clipped - 9 lines]
> hokieguy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=21915
> View this thread: http://www.excelforum.com/showthread.php?threadid=378065

Signature

Dave Peterson

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.