Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
Chris Chris is offline
external usenet poster
 
Posts: 237
Default Copy Word table into excel

I have a few documents that are over 50 pages long that have requirements in
a word table. The requirements have formatting such as Carriage returns,
bullets, and indents. What I would like to do is for each cell in word to
copy over to a single cell in excel. the problem is that every one cell in
word converts to many in excel ... which I'm thinking is mostly due to
formatting.

Is there an easy way to do this that I'm just missing?
Any ideas I should try.... thanks

Chris
  #2   Report Post  
Posted to microsoft.public.word.tables
Stefan Blom[_3_] Stefan Blom[_3_] is offline
external usenet poster
 
Posts: 6,897
Default Copy Word table into excel

For each paragraph mark ( with nonprinting marks displayed) within a Word
cell you will get an additional row. Try deleting the paragraph marks before
copying; to accomplish that, you can use Find and Replace.

--
Stefan Blom
Microsoft Word MVP



"Chris" wrote in message
...
I have a few documents that are over 50 pages long that have requirements
in
a word table. The requirements have formatting such as Carriage returns,
bullets, and indents. What I would like to do is for each cell in word to
copy over to a single cell in excel. the problem is that every one cell in
word converts to many in excel ... which I'm thinking is mostly due to
formatting.

Is there an easy way to do this that I'm just missing?
Any ideas I should try.... thanks

Chris




Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy a 2007 Word table into Excel tinks Microsoft Word Help 2 February 12th 10 06:56 PM
copy a table from word to excel as cells Greg Middleton Tables 5 December 14th 07 03:53 PM
How can I copy an Excel table, w/ its header and footer into Word? DonD Microsoft Word Help 2 July 14th 07 07:09 AM
Copy word table to Excel w/o splitting row Dorna Tucker Tables 2 December 15th 05 09:46 PM
Copy excel into word, rotate table 90 left, maintain formatting Bob Tables 12 July 15th 05 11:34 PM


All times are GMT +1. The time now is 05:59 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"