Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
hg
 
Posts: n/a
Default Copy Word table into Excel cell by cell

Is there a way to copy a Word table into Excel cell by cell when the Word
cells contains multiple paragraphs of text? (Excel breaks each Word cell into
several rows.)
  #2   Report Post  
Andy Brown
 
Posts: n/a
Default

Is there a way to copy a Word table into Excel cell by cell when the Word
cells contains multiple paragraphs of text? (Excel breaks each Word cell

into
several rows.)


In Word, hit CTRL+Shift+* to turn on "Show non-printing characters". This
should show there are 2 "reverse p" characters (paragraph markers) between
each para. So then do a Replace (CTRL+H) -- in Find What, use "^p^p"
(without the quotes) ; in Replace With, use "!!!" (without the quotes).
Click Replace All, then close the dialog box.

Then you can select the whole table & copy to Excel. Once it's there, you
can use Replace (CTRL+H) again -- Find What = "!!!" (without the quotes) ;
in Replace With, click in the box and *while holding down ALT* type 0010 on
the *Number* keypad. Release ALT, then hold it down again and type 0010 on
the Number keypad (again). Then click Replace All.

HTH,
Andy


  #3   Report Post  
hg
 
Posts: n/a
Default

Thank you very much, Andy.

I copied the table to the Excel but got a message box sayinig that the
formula is too long when replacing the "!!!".



"Andy Brown" wrote:

Is there a way to copy a Word table into Excel cell by cell when the Word
cells contains multiple paragraphs of text? (Excel breaks each Word cell

into
several rows.)


In Word, hit CTRL+Shift+* to turn on "Show non-printing characters". This
should show there are 2 "reverse p" characters (paragraph markers) between
each para. So then do a Replace (CTRL+H) -- in Find What, use "^p^p"
(without the quotes) ; in Replace With, use "!!!" (without the quotes).
Click Replace All, then close the dialog box.

Then you can select the whole table & copy to Excel. Once it's there, you
can use Replace (CTRL+H) again -- Find What = "!!!" (without the quotes) ;
in Replace With, click in the box and *while holding down ALT* type 0010 on
the *Number* keypad. Release ALT, then hold it down again and type 0010 on
the Number keypad (again). Then click Replace All.

HTH,
Andy



  #4   Report Post  
hg
 
Posts: n/a
Default

I deleted the row that caused the problem. It works!!! Thanks again!

"hg" wrote:

Thank you very much, Andy.

I copied the table to the Excel but got a message box sayinig that the
formula is too long when replacing the "!!!".



"Andy Brown" wrote:

Is there a way to copy a Word table into Excel cell by cell when the Word
cells contains multiple paragraphs of text? (Excel breaks each Word cell

into
several rows.)


In Word, hit CTRL+Shift+* to turn on "Show non-printing characters". This
should show there are 2 "reverse p" characters (paragraph markers) between
each para. So then do a Replace (CTRL+H) -- in Find What, use "^p^p"
(without the quotes) ; in Replace With, use "!!!" (without the quotes).
Click Replace All, then close the dialog box.

Then you can select the whole table & copy to Excel. Once it's there, you
can use Replace (CTRL+H) again -- Find What = "!!!" (without the quotes) ;
in Replace With, click in the box and *while holding down ALT* type 0010 on
the *Number* keypad. Release ALT, then hold it down again and type 0010 on
the Number keypad (again). Then click Replace All.

HTH,
Andy



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
How can I use word wrap in a merged cell in excel 2000? PartnersHC Excel Discussion (Misc queries) 4 October 18th 09 10:02 PM
getting specific info from a word document into excel smintey Excel Discussion (Misc queries) 3 December 8th 04 09:20 PM
Paste rows of numbers from Word into single Excel cell BecG Excel Discussion (Misc queries) 1 December 8th 04 05:55 PM
How to convert the table in word to excel sheet? Santhosh Excel Discussion (Misc queries) 1 December 2nd 04 11:15 AM
Copying an Excel spreadsheet to a Word document KG Excel Discussion (Misc queries) 1 November 28th 04 08:38 PM


All times are GMT +1. The time now is 08:53 PM.

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

About Us

"It's about Microsoft Excel"