Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 18th 05, 01:57 AM
phoenix
 
Posts: n/a
Default How to convert Word table with paragraphing to Excel?

Is there any way to convert a Word table that has multiple paragraphs in each
cell to Excel without going through a third-party converter? I have several
hundred rows to convert, and copying and pasting each paragraph into the
Excel Workbook is not a viable option. The Table to Text tool in Word also
doesn't give me control over the paragraphing. With everything I've tried,
each paragraph winds up in a separate row in Excel.

Thanks for any support.

  #2   Report Post  
Old February 18th 05, 02:42 AM
Dave Peterson
 
Posts: n/a
Default

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).



phoenix wrote:

Is there any way to convert a Word table that has multiple paragraphs in each
cell to Excel without going through a third-party converter? I have several
hundred rows to convert, and copying and pasting each paragraph into the
Excel Workbook is not a viable option. The Table to Text tool in Word also
doesn't give me control over the paragraphing. With everything I've tried,
each paragraph winds up in a separate row in Excel.

Thanks for any support.


--

Dave Peterson
  #3   Report Post  
Old February 18th 05, 03:49 PM
CyberTaz
 
Posts: n/a
Default

Perhaps even easier/quicker - Do the Find & Replace in Word to replace to
substitute Manual Line Breaks (^l) for Paragraph Marks (^p). When you copy &
paste the table thecell content will match up cell for cell instead of
getting separated.

Hope this is useful |:)
"Dave Peterson" wrote:

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).



phoenix wrote:

Is there any way to convert a Word table that has multiple paragraphs in each
cell to Excel without going through a third-party converter? I have several
hundred rows to convert, and copying and pasting each paragraph into the
Excel Workbook is not a viable option. The Table to Text tool in Word also
doesn't give me control over the paragraphing. With everything I've tried,
each paragraph winds up in a separate row in Excel.

Thanks for any support.


--

Dave Peterson

  #4   Report Post  
Old February 18th 05, 10:49 PM
Dave Peterson
 
Posts: n/a
Default

When I did that, each new line within the cell in the MSWord table still went to
a new cell in excel.

I think the OP wanted those lines all within the same excel cell (separated by
alt-enters).



CyberTaz wrote:

Perhaps even easier/quicker - Do the Find & Replace in Word to replace to
substitute Manual Line Breaks (^l) for Paragraph Marks (^p). When you copy &
paste the table thecell content will match up cell for cell instead of
getting separated.

Hope this is useful |:)
"Dave Peterson" wrote:

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).



phoenix wrote:

Is there any way to convert a Word table that has multiple paragraphs in each
cell to Excel without going through a third-party converter? I have several
hundred rows to convert, and copying and pasting each paragraph into the
Excel Workbook is not a viable option. The Table to Text tool in Word also
doesn't give me control over the paragraphing. With everything I've tried,
each paragraph winds up in a separate row in Excel.

Thanks for any support.


--

Dave Peterson


--

Dave Peterson
  #5   Report Post  
Old February 18th 05, 11:45 PM
CyberTaz
 
Posts: n/a
Default

Curious- I confirmed the technique before I posted & had perfect results
using '03. Are you perhaps using a different version? |:)

"Dave Peterson" wrote:

When I did that, each new line within the cell in the MSWord table still went to
a new cell in excel.

I think the OP wanted those lines all within the same excel cell (separated by
alt-enters).



CyberTaz wrote:

Perhaps even easier/quicker - Do the Find & Replace in Word to replace to
substitute Manual Line Breaks (^l) for Paragraph Marks (^p). When you copy &
paste the table thecell content will match up cell for cell instead of
getting separated.

Hope this is useful |:)
"Dave Peterson" wrote:

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).



phoenix wrote:

Is there any way to convert a Word table that has multiple paragraphs in each
cell to Excel without going through a third-party converter? I have several
hundred rows to convert, and copying and pasting each paragraph into the
Excel Workbook is not a viable option. The Table to Text tool in Word also
doesn't give me control over the paragraphing. With everything I've tried,
each paragraph winds up in a separate row in Excel.

Thanks for any support.

--

Dave Peterson


--

Dave Peterson



  #6   Report Post  
Old February 18th 05, 11:56 PM
Debra Dalgleish
 
Posts: n/a
Default

No, your technique doesn't work in Excel 2003 for me either.

CyberTaz wrote:
Curious- I confirmed the technique before I posted & had perfect results
using '03. Are you perhaps using a different version? |:)

"Dave Peterson" wrote:


When I did that, each new line within the cell in the MSWord table still went to
a new cell in excel.

I think the OP wanted those lines all within the same excel cell (separated by
alt-enters).



CyberTaz wrote:

Perhaps even easier/quicker - Do the Find & Replace in Word to replace to
substitute Manual Line Breaks (^l) for Paragraph Marks (^p). When you copy &
paste the table thecell content will match up cell for cell instead of
getting separated.

Hope this is useful |:)
"Dave Peterson" wrote:


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).



phoenix wrote:

Is there any way to convert a Word table that has multiple paragraphs in each
cell to Excel without going through a third-party converter? I have several
hundred rows to convert, and copying and pasting each paragraph into the
Excel Workbook is not a viable option. The Table to Text tool in Word also
doesn't give me control over the paragraphing. With everything I've tried,
each paragraph winds up in a separate row in Excel.

Thanks for any support.

--

Dave Peterson


--

Dave Peterson




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

  #7   Report Post  
Old February 19th 05, 12:01 AM
Dave Peterson
 
Posts: n/a
Default

I used Office 2003, but it doesn't work in xl2002 or xl2k or xl97 (if my memory
serves me correctly).



CyberTaz wrote:

Curious- I confirmed the technique before I posted & had perfect results
using '03. Are you perhaps using a different version? |:)

"Dave Peterson" wrote:

When I did that, each new line within the cell in the MSWord table still went to
a new cell in excel.

I think the OP wanted those lines all within the same excel cell (separated by
alt-enters).



CyberTaz wrote:

Perhaps even easier/quicker - Do the Find & Replace in Word to replace to
substitute Manual Line Breaks (^l) for Paragraph Marks (^p). When you copy &
paste the table thecell content will match up cell for cell instead of
getting separated.

Hope this is useful |:)
"Dave Peterson" wrote:

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).



phoenix wrote:

Is there any way to convert a Word table that has multiple paragraphs in each
cell to Excel without going through a third-party converter? I have several
hundred rows to convert, and copying and pasting each paragraph into the
Excel Workbook is not a viable option. The Table to Text tool in Word also
doesn't give me control over the paragraphing. With everything I've tried,
each paragraph winds up in a separate row in Excel.

Thanks for any support.

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
paste excel table to word Stephen Excel Worksheet Functions 1 January 23rd 05 03:27 PM
Paste table from excel to word Stephen Excel Worksheet Functions 0 January 22nd 05 11:15 AM
Convert Word Table to Excel Spreadsheet [email protected] Excel Discussion (Misc queries) 1 January 18th 05 10:57 PM
Copy Word table into Excel cell by cell hg Excel Discussion (Misc queries) 3 December 15th 04 04:43 PM
How to convert the table in word to excel sheet? Santhosh Excel Discussion (Misc queries) 1 December 2nd 04 10:15 AM


All times are GMT +1. The time now is 12:49 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017